[PLUG] postgresql select query

Carlos Konstanski ckonstanski at pippiandcarlos.com
Sat Jan 8 20:45:04 UTC 2011


SELECT ID,START_DATE,END_DATE,CREATEDBY,NAME FROM businesses WHERE id in ()
ORDER BY name ASC;

The above query will fail in postgresql 9.0 because of the empty list in the
WHERE clause. Is this standard ANSI SQL behavior, or is it a postgresql quirk?



More information about the PLUG mailing list