Skip site navigation (1) Skip section navigation (2)

Re: Patch for adding DATACUBE operator

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sumit <sumit(at)gdit(dot)iiit(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch for adding DATACUBE operator
Date: 2003-06-30 14:33:54
Message-ID: 4592.1056983634@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
sumit <sumit(at)gdit(dot)iiit(dot)net> writes:
> In keeping with this, we first define the syntax of a CUBE statement as follows:

> SELECT <field list><aggregate list>
> INTO <destination table>
> FROM <table expression>
> WHERE <search condition>
> GROUP BY <aggregate list>
> HAVING <search condition>
> WITH CUBE;

SQL99 defines a GROUP BY CUBE(...) operation, which seems to do the same
thing as this.  Why are you using a nonstandard syntax?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Carlos Guzman AlvarezDate: 2003-06-30 14:49:26
Subject: Re: Question about array read using protocol 3.0 implementation
Previous:From: scott.marloweDate: 2003-06-30 12:19:19
Subject: Re: When will table partitioning be available..

pgsql-patches by date

Next:From: Joe ConwayDate: 2003-06-30 15:37:17
Subject: Re: polymorphic arguments and return type for PL/pgSQL
Previous:From: Serguei MokhovDate: 2003-06-30 14:13:19
Subject: Re: pgAdmin3 translation request into Russian

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group