Re: calling a function over several rows - Mailing list pgsql-general

Merlin Moncure wrote:
> On Tue, Nov 17, 2009 at 1:02 AM, Adam Rich <adam.r@sbcglobal.net> wrote:
>> Hello,
>> There is an existing function which takes an integer and returns a record.
>>  I need to call this function with every integer in a table.  Is there a
>> simple shortcut for doing this?
>>
>> I'm looking for something like:
>>
>> select f.*
>> from function(t.value) f, table t
>
> select (f).* from (select function(t.value) as f from table t) q;
>
> merlin
>

Thanks, that's perfect, and much faster than the one I came up with in
the interim:

select (f(t.value)).* from table t;