pgSQL query error

Posted by running4surival on Stack Overflow See other posts from Stack Overflow or by running4surival
Published on 2010-05-14T17:27:53Z Indexed on 2010/05/14 17:44 UTC
Read the original article Hit count: 191

Filed under:

pgsql

|

query

|

sql

|

error

i tried using this query:

"SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;"

and I'm getting this error:

ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function

can anyone explain how i can work around this?

© Stack Overflow or respective owner

Related posts about pgsql

Zendframework / PgSQL fetchAll orderby

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a pgsql table with fields id, identifier, name. id serial NOT NULL, identifier character varying(16), name character varying(128) I want to fetchAll values from the table orderby identifier. but identifier is having values 12, 100, 200, 50 and after $table->fetchAll(null, 'identifier'); is… >>> More
Excel and pgSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I import data from a excel sheet onto a PGSQL database on linux? >>> More
Postgres: Using function variable names in pgsql function

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have written a pgsql function along the lines of what's shown below. How can I get rid of the $1, $2, etc. and replace them with the real argument names to make the function code more readable? Regards Peter CREATE OR REPLACE FUNCTION InsertUser ( UserID UUID, FirstName CHAR(10), … >>> More
Regular expression replace in PL/pgSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
If I have the following input (excluding quotes): "The ancestral territorial imperatives of the trumpeter swan" How can I collapse all multiple spaces to a single space so that the input is transformed to: "The ancestral territorial imperatives of the trumpeter swan" This is going to… >>> More
want to change pgsql port

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, currently install pgsql is running on port 1486 now I want to change this port to 5433, So how I've proceed for this....????? Thanx in advance.. >>> More

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More