Re: PL/pgSQL: How to return two columns and multiple rows

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Jun 18, 2015 at 12:00 PM, Sven Geggus <lists@xxxxxxxxxxxxxxxxxxxxx> wrote:

David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

> Assuming you are on 9.3+ what you want to use is LATERAL

OK, how is such a query supposed to look like?

assuming "select myfunc(col1,col2) from mytable" works as the inner select?

​Syntax, description, and examples for a simple lateral query are documented here:

http://www.postgresql.org/docs/9.3/static/sql-select.html

David J.

​