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?