I am using Postgresql 9.1.0. I found that following GROUP BY query works in my DB :-
\d t1 Table "public.t1" Column | Type | Modifiers --------+---------+----------- i | integer | not null nam | text | Indexes: "t1_pkey" PRIMARY KEY, btree (i) select i,nam from t1 group by i; i | nam ---+----- (0 rows) I think the query should show an error as I did not maintain group by standard. Does anyone know why it does not show syntax error?