Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL: How to return two columns and multiple rows - Mailing list pgsql-general

From David G. Johnston
Subject Re: PL/pgSQL: How to return two columns and multiple rows
Date
Msg-id CAKFQuwYHvLJUMvuM6+bjdeZLBPA2KX2oAy4WZ=YNCj-F8=nEwA@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL: How to return two columns and multiple rows  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
Tree view
On Thursday, June 18, 2015, Chris Travers <chris.travers@gmail.com> wrote:


Select (myfunc('foo','bar')).*;



This should be avoided.  Use lateral instead,or a cte a/o offset 0.  My_func is evaluated twice (once per column) if called this way  


Or
Select * from myfunc('foo','bar');

 
This is ok
 
David J.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL: How to return two columns and multiple rows
Next
From: Sven Geggus
Date:
Subject: Re: PL/pgSQL: How to return two columns and multiple rows