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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-07-28 13:03:29 Re: cheaper snapshots
Previous Message Hannu Krosing 2011-07-28 10:50:49 Re: cheaper snapshots