From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Cc: | "Neil Conway" <neilc(at)samurai(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | refreshed table function support |
Date: | 2007-05-06 16:53:03 |
Message-ID: | 162867790705060953w4ee642ccoc6925b48f7fc6347@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Hello
This patch contains implementation of table functions defined in ANSI
SQL 2003 (Conformance with SQL2003: T326 Table functions). Patch adds
new proargmode PROARGMODE_TABLE (based on PROARGMODE_OUT). Columns of
output table are similar OUT arguments, but don't generate any
variables.
Proposal: http://archives.postgresql.org/pgsql-hackers/2007-02/msg00318.php
Description: SIGMOD Record, Vol. 33, No. 1, March 2004
Patch contains three diffs:
* pgdumpclean .. small readability fix for pg_dump.c
* tabfce .. implementation of table functions
* plpgsql-tabfce .. table expression support for plpgsql's return stmt
This patch can broke applications which scan argmodes. Plpgsql support
is separated because plpgsql implementation isn't standardised. But
current plpgsql hasn't any method for one statement table output from
function, and table expression is clean and simple tool for it.
Older version was broken by enum patch and scrollable cursor patch.
Older version didn't dump table functions correctly. It's fixed now.
Regards
Pavel Stehule
Attachment | Content-Type | Size |
---|---|---|
pgdumpclean.diff | text/x-patch | 636 bytes |
tabfce.diff | text/x-patch | 23.2 KB |
plpgsql-tabfce.diff | text/x-patch | 12.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-05-06 16:59:31 | Re: refreshed table function support |
Previous Message | Andrew Dunstan | 2007-05-06 15:02:42 | Re: Enable integer datetimes by default |