| 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: | Whole Thread | Raw Message | 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 |