Re: [BUGS] BUG #5342: Error

2010-02-23 Thread Euler Taveira de Oliveira
Shilpa.R escreveu: > select agegrp, cartype, risk, count(*) as count > from trset > group by risk, grouping sets ((agegrp,cartype)) > This is not a bug. If you had searched the fine manual, you would figure out that grouping sets is not supported by PostgreSQL yet. -- Euler Taveira de Oliveir

Re: [BUGS] BUG #5342: Error

2010-02-23 Thread Kevin Grittner
"Shilpa.R" 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 r

[BUGS] BUG #5342: Error

2010-02-23 Thread Shilpa.R
The following bug has been logged online: Bug reference: 5342 Logged by: Shilpa.R Email address: shilpar1...@gmail.com PostgreSQL version: PostgreSQL Data Operating system: Windows Xp Description:Error Details: I found an error stating syntax error near or at sets i