query works in psql, but not thru JDBC - Mailing list pgsql-interfaces

Hi.

I'm running this query, which is constructed from parameters passed to a
function.

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

SQL State : NULL
Error Code : 0
------------------------

Why does it work from the command line and not through JDBC?

Thanks in advance.

--Arsalan.