"Arsalan Zaidi" <azaidi(at)directi(dot)com> writes:
> SELECT * FROM users WHERE userid = 4 ORDER BY name LIMIT 20 OFFSET 0
> When I run it from the command line inpsql, It works just fine, but when I
> run it using the Postgresql JDBC driver (executeQuery()), I get this error
> Err Mesg : ERROR: Attribute users.name must be GROUPed or used in an
> aggregate function
Curious. Does JDBC alter the query at all before it sends it? Try
turning on query logging at the postmaster, and look in the postmaster
log to see what is actually being sent.
regards, tom lane