Обсуждение: BUG #5342: Error

The following bug has been logged online:

Bug reference:      5342
Logged by:          Shilpa.R
Email address:      shilpar1800@gmail.com
PostgreSQL version: PostgreSQL Data
Operating system:   Windows Xp
Description:        Error
Details:

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

"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

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
  http://www.timbira.com/