Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] postgresql how to duplicate rows in result. - Mailing list pgsql-general

From John McKown
Subject Re: [GENERAL] postgresql how to duplicate rows in result.
Date
Msg-id CAAJSdjitXNL0X-maqiAY5NtZ9kC7=2sK_uqaP3uKtecHM4pRJQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] postgresql how to duplicate rows in result.  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
On Tue, Feb 14, 2017 at 2:50 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
​<snip>


IMO, lateral join (available as of 9.3) is faster and simpler.

​And, nicely, I've learned something new. I've never used a LATERAL join before. Interesting.​

 

merlin



--
"Irrigation of the land with sewater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion

Maranatha! <><
John McKown

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] postgresql how to duplicate rows in result.
Next
From: Nikolai Zhubr
Date:
Subject: Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows,9.5.5 (EDB binary).