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 CAKFQuwbjtF2wq1P5tcH8wHJDb4nWi=ic0UdQyubk2WJKuYw0SQ@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL: How to return two columns and multiple rows  (Sven Geggus <lists@fuchsschwanzdomain.de>)
List pgsql-general
Tree view
On Thu, Jun 18, 2015 at 12:00 PM, Sven Geggus <lists@fuchsschwanzdomain.de> wrote:
David G. Johnston <david.g.johnston@gmail.com> 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:


David J.
​

pgsql-general by date:

Previous
From: Sven Geggus
Date:
Subject: Re: PL/pgSQL: How to return two columns and multiple rows
Next
From: "Sheena, Prabhjot"
Date:
Subject: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)