Patch for adding DATACUBE operator - Mailing list pgsql-patches

From sumit
Subject Patch for adding DATACUBE operator
Date
Msg-id Pine.LNX.4.44.0306301515470.27097-500000@students.iiit.net
Whole thread Raw
Responses Re: Patch for adding DATACUBE operator  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-patches by date:

Previous
From: Joe Conway
Date:
Subject: polymorphic arguments and return type for PL/pgSQL
Next
From: "Andrew Dunstan"
Date:
Subject: Re: Patch for adding DATACUBE operator