Postgres Pro
Downloads
Home   >   mailing lists

Re: Passing dynamic parameters to a table-returning function - Mailing list pgsql-general

From Moshe Jacobson
Subject Re: Passing dynamic parameters to a table-returning function
Date
Msg-id CAJ4CxL=zU3afsHXGcm81rvXZvWNcHsCg-2aKXOq2ADK9oFCOmA@mail.gmail.com
Whole thread Raw
In response to Passing dynamic parameters to a table-returning function  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
Tree view 
On Tue, Feb 5, 2013 at 9:09 AM, Amit Kapila <amit.kapila@huawei.com> wrote:

>
> Can you try with RETURN NEXT syntax. For example, refer below link:
>
> http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PL
> PGSQL-STATEMENTS-RETURNING
>

Thanks for your response, but I'm looking for simple SQL syntax that can be
executed outside of a stored procedure.

Moshe

--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com

"People don't multitask because they're good at it. They do it because they
are more distracted" -- David
Sanbonmatsu<http://www.plosone.org/article/info%3Adoi%2F10.1371%2Fjournal.pone.0054402>

pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: .pgpass and root: a problem
Next
From: Tom Lane
Date:
Subject: Re: cleanup of pgsql_tmp directory