From: | sumit <sumit(at)gdit(dot)iiit(dot)net> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Patch for adding DATACUBE operator |
Date: | 2003-06-30 10:04:11 |
Message-ID: | Pine.LNX.4.44.0306301515470.27097-500000@students.iiit.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hi!
We have added the CUBE operator for PostgreSQL. Please find the
attached patch.
Another thing to note is that the file datacube.c should
be placed in src/backend/tcop/ and datacube.h should be in src/include.
The syntax of the query is
SELECT <field list><aggregate list>
INTO <destination table>
FROM <table expression>
WHERE <search condition>
GROUP BY <aggregate list>
HAVING <search condition>
WITH CUBE;
An example along with the output is provided in the
README.datacube file. Kindly have a look. Let us know your response.
Srikanth M
Sumit Kumar Mukherjee
Attachment | Content-Type | Size |
---|---|---|
datacube_patch | text/plain | 12.3 KB |
datacube.c | text/plain | 10.5 KB |
datacube.h | text/plain | 872 bytes |
README.datacube | text/plain | 4.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-06-30 11:09:54 | Re: Patch for adding DATACUBE operator |
Previous Message | Carlos Guzman Alvarez | 2003-06-30 10:02:20 | Re: Question about array read using protocol 3.0 implementation |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-06-30 11:09:54 | Re: Patch for adding DATACUBE operator |
Previous Message | Joe Conway | 2003-06-30 06:05:52 | polymorphic arguments and return type for PL/pgSQL |