Re: "RETURNS SETOF" function question

From: "Kynn Jones" <kynnjo(at)gmail(dot)com>
To: "Erik Jones" <erik(at)myemma(dot)com>
Cc: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: "RETURNS SETOF" function question
Date: 2008-02-25 22:10:31
Message-ID: c2350ba40802251410q2880bab9u53fbc921e619ab47@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Feb 24, 2008 at 7:08 PM, Erik Jones <erik(at)myemma(dot)com> wrote:

>
> There was an article that covered this in the Postgres Online Journal
> (
> http://www.postgresonline.com/journal/index.php?/categories/6-pl-programming).
> Basically, do this:
>
> CREATE OR REPLACE FUNCTION foo(text, text)
> RETURNS SETOF text
> $$
> SELECT * FROM foo($1, $2);
> $$
> LANGUAGE sql;
>

That one goes straight into my (still tiny) bag o' Pg tricks. It worked
like a charm.

Thanks!

G.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Maciej Sieczka 2008-02-25 22:41:08 how to auto GRANT custom ACL on a new table?
Previous Message Geoffrey 2008-02-25 20:33:07 disabling triggers, constaints and so on