Skip site navigation (1) Skip section navigation (2)

Re: Table function support

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Table function support
Date: 2007-02-17 03:25:29
Message-ID: 200702170325.l1H3PTm27884@momjian.us (view raw or flat)
Thread:
Lists: pgsql-patches
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 allows using SQL2003 syntax for set returning functions. It is 
> based on using new type of argmode - PROARGMODE_TABLE.
> 
> Proposal: http://archives.postgresql.org/pgsql-hackers/2007-02/msg00318.php
> 
> Sample:
> 
> CREATE FUNCTION foof(a int)
> RETURNS TABLE(a int, b int) AS
> $$ SELECT x, y FROM Foo WHERE x < a $$ LANGUAGE sql;
> 
> CREATE FUNCTION fooff(a int)
> RETURNS TABLE(a int, b int) AS $$
> BEGIN
>   RETURN TABLE(SELECT * FRON Foo WHERE x < a);
> END; $$ LANGUAGE plpgsql;
> 
> This patch enhance plpgsql stmt return too (table expression support).
> 
> Conformance with SQL2003:
> T326 	Table functions
> 
> Description: SIGMOD Record, Vol. 33, No. 1, March 2004
> 
> Regards
> Pavel Stehule
> 
> _________________________________________________________________
> Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. 
> http://messenger.msn.cz/

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
> 
>                 http://www.postgresql.org/about/donate

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

In response to

pgsql-patches by date

Next:From: FAST PostgreSQLDate: 2007-02-17 03:28:20
Subject: Re: WIP patch - INSERT-able log statements
Previous:From: Bruce MomjianDate: 2007-02-17 03:11:36
Subject: Re: [BUGS] BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group