"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