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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Sven Geggus <lists(at)fuchsschwanzdomain(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PL/pgSQL: How to return two columns and multiple rows
Date: 2015-06-18 16:11:54
Message-ID: CAKFQuwbjtF2wq1P5tcH8wHJDb4nWi=ic0UdQyubk2WJKuYw0SQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 18, 2015 at 12:00 PM, Sven Geggus <lists(at)fuchsschwanzdomain(dot)de>
wrote:

> David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)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:

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

David J.
​

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sheena, Prabhjot 2015-06-18 17:09:10 PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
Previous Message Sven Geggus 2015-06-18 16:00:00 Re: PL/pgSQL: How to return two columns and multiple rows