"Shilpa.R" <shilpar1800@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