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

From: Sven Geggus <lists(at)fuchsschwanzdomain(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL: How to return two columns and multiple rows
Date: 2015-06-18 16:00:00
Message-ID: mlupu0$3mt$1@solar.geggus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Sven

--
Software patents are the software project equivalent of land mines: Each
design decision carries a risk of stepping on a patent, which can destroy
your project. (Richard M. Stallman)
/me is giggls(at)ircnet, http://sven.gegg.us/ on the Web

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-06-18 16:11:54 Re: PL/pgSQL: How to return two columns and multiple rows
Previous Message Alvaro Herrera 2015-06-18 15:49:42 Re: PL/pgSQL: How to return two columns and multiple rows