AI Rumman wrote on 24.03.2012 09:06:
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?
That's an enhancement in 9.1
As you included the primary key in the group by clause the rows are going to be unique anyway and no additional columns are necessary.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
