| From: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Passing dynamic parameters to a table-returning function |
| Date: | 2013-02-05 17:34:47 |
| Message-ID: | CAJ4CxL=zU3afsHXGcm81rvXZvWNcHsCg-2aKXOq2ADK9oFCOmA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 5, 2013 at 9:09 AM, Amit Kapila <amit(dot)kapila(at)huawei(dot)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(at)neadwerx(dot)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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ROBERT KLAUS | 2013-02-05 17:52:36 | cleanup of pgsql_tmp directory |
| Previous Message | Shaun Thomas | 2013-02-05 17:15:32 | .pgpass and root: a problem |