Patch for adding DATACUBE operator

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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