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
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
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