Re: concatenating setof functions - Mailing list pgsql-general

From Tom Lane
Subject Re: concatenating setof functions
Date
Msg-id 9956.1176752334@sss.pgh.pa.us
Whole thread Raw
In response to concatenating setof functions  ("Frederick Ross" <madhadron@gmail.com>)
List pgsql-general
"Frederick Ross" <madhadron@gmail.com> writes:
> But say I have a table with an integer column.  If I had a pure SQL
> function, I could call
> select twohundreds(i) from table;
> and get a properly concatenated list of the rows resulting from
> applying twohundreds to each row of table.  This is deprecated
> according to the documentation, and it doesn't work at all with
> PLPGSQL, so how should I go about doing it?

I believe you can make an end-run around the implementation restriction
by creating a SQL-language function that's a wrapper around your plpgsql
function.

            regards, tom lane

pgsql-general by date:

Previous
From: "Frederick Ross"
Date:
Subject: concatenating setof functions
Next
From: "Ketema"
Date:
Subject: Dynamic DDL