| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Shilpa(dot)R" <shilpar1800(at)gmail(dot)com>,<pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #5342: Error |
| Date: | 2010-02-23 14:39:51 |
| Message-ID: | 4B839457020000250002F4EF@gw.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Shilpa.R" <shilpar1800(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira de Oliveira | 2010-02-23 14:44:17 | Re: BUG #5342: Error |
| Previous Message | Michael Renner | 2010-02-23 13:22:14 | Re: BUG #5103: "pg_ctl -w (re)start" fails with custom unix_socket_directory |