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

Re: How to use CreateFunctionStmt's RETURN TABLE?

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: _石头 <tanjia76(at)qq(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How to use CreateFunctionStmt's RETURN TABLE?
Date: 2011-07-28 12:10:27
Message-ID: CAHHcrepcagQSyEoCc7xqzFpmhLCE-5JvH+zPOUXtvSAe-Xj2Xw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2011/7/26 _石头 <tanjia76(at)qq(dot)com>:
[... cut ...]
>           I do not know how to use the second syntax:RETURNS TABLE '('
> table_func_column_list ')' createfunc_opt_list opt_definition.
>           May someone help me to write a simple example of this syntax!
>  Thank you very much. Looking forward for your help!

(I'm supposing that you are talking about the syntax of 'CREATE
FUNCTION' itself and not about the bison entry in that file.)

See the docs [1] and this post [2]. They could help you.

[1] http://www.postgresql.org/docs/current/static/sql-createfunction.html
[2] http://www.postgresonline.com/journal/archives/201-returns-table.html

Best regards,
-- 
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-07-28 13:03:29
Subject: Re: cheaper snapshots
Previous:From: Hannu KrosingDate: 2011-07-28 10:50:49
Subject: Re: cheaper snapshots

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