From: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Олег Царев <zabivator(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Implementation of GROUPING SETS (T431: Extended grouping capabilities) |
Date: | 2009-05-13 13:01:40 |
Message-ID: | 20090513130140.GH8468@eddie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, May 13, 2009 at 06:29:41AM +0200, Pavel Stehule wrote:
> 2009/5/13 Joshua Tolley <eggyknap(at)gmail(dot)com>:
> > On Tue, May 12, 2009 at 11:20:14PM +0200, Pavel Stehule wrote:
> >> this patch has some bugs but it is good prototype (it's more stable
> >> than old patch):
> >
> > I'm not sure if you're at the point that you're interested in bug reports, but
> > here's something that didn't behave as expected:
> >
> > 5432 josh(at)josh*# create table gsettest (prod_id integer, cust_id integer,
> > quantity integer);
> > CREATE TABLE
> > 5432 josh(at)josh*# insert into gsettest select floor(random() * 10)::int,
> > floor(random() * 20)::int, floor(random() * 10)::int from generate_series(1,
> > 100);
> > INSERT 0 100
> > 5432 josh(at)josh*# select prod_id, cust_id, sum(quantity) from gsettest group by
> > cube (prod_id, cust_id) order by 1, 2;
> > prod_id | cust_id | sum
> > ---------+---------+-----
> > 5 | 7 | 4
> > 8 | 16 | 3
> > 9 | 19 | 8
> > 4 | 13 | 3
> > 8 | 8 | 15
> > 5 | 2 | 4
> > 7 | 6 | 7
> > 6 | 6 | 3
> > </snip>
> >
> > Note that the results aren't sorted. The following, though, works around it:
>
> I thing, so result should not be sorted - it's same like normal group by.
Normal GROUP BY wouldn't have ignored the ORDER BY clause I included.
- Josh
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2009-05-13 13:12:51 | Re: Implementation of GROUPING SETS (T431: Extended grouping capabilities) |
Previous Message | wjzeng | 2009-05-13 12:41:44 | how to insure libpq(dll/so) for thread-safety? |