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

From Sven Geggus
Subject Re: PL/pgSQL: How to return two columns and multiple rows
Date
Msg-id mlupu0$3mt$1@solar.geggus.net
Whole thread Raw
In response to PL/pgSQL: How to return two columns and multiple rows  (Sven Geggus <lists@fuchsschwanzdomain.de>)
Responses Re: PL/pgSQL: How to return two columns and multiple rows  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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?

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@ircnet, http://sven.gegg.us/ on the Web

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PL/pgSQL: How to return two columns and multiple rows
Next
From: "David G. Johnston"
Date:
Subject: Re: PL/pgSQL: How to return two columns and multiple rows