Unix Technical Forum

Re: refreshed table function support

This is a discussion on Re: refreshed table function support within the Pgsql Patches forums, part of the PostgreSQL category; --> Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Patches

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-18-2008, 10:01 AM
Bruce Momjian
 
Posts: n/a
Default Re: refreshed table function support


Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Pavel Stehule wrote:
> 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...2/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, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match


--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:54 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com