"Raymond O'Donnell" <rod@xxxxxx> writes:
> On 18/06/2015 13:36, Sven Geggus wrote:
>> I would like to be able to do something like this:
>>
>> select myfunc('foo','bar');
>> or
>> select myfunc(foo, bar) from foobartable;
>> or even
>> select myfunc(foo, bar), 'baz' as baz from foobartable;
> You need to do:
> select * from myfunc('foo','bar');
That's enough to expand the output from a simple function call. If you
want to do something like Sven's later examples, the best way is with
LATERAL:
select f.*, 'baz' as baz from foobartable, lateral myfunc(foo, bar) as f;
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
