Re: "RETURNS SETOF" function question

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.