[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

Re: [BUGS] BUG #5342: Error

2010-02-23 Thread Kevin Grittner
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

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 Oliveira