"Shilpa.R" <shilpar1...@gmail.com> wrote:
 
> PostgreSQL version: PostgreSQL Data
 
That's not very informative; what do you get from running?:
 
select version();
 
> I found an error stating syntax error near or at sets in the
> following query
> select agegrp, cartype, risk, count(*) as count
> from trset
> group by risk, grouping sets ((agegrp,cartype))
 
I'm not familiar with "grouping sets" -- where in the PostgreSQL
documentation do you find those defined?
 
-Kevin

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to