Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Combing row returning functions using "ROWS FROM"? - Mailing list pgsql-general

From Guyren Howe
Subject [GENERAL] Combing row returning functions using "ROWS FROM"?
Date
Msg-id B21959E8-80D7-4C68-927F-1406B2BE0AA9@gmail.com
Whole thread Raw
List pgsql-general
Tree view
I just noticed the reference to combining set returning functions using “ROWS FROM” at https://www.postgresql.org/docs/10/static/queries-table-expressions.html#queries-tablefunctions

I have not previously noticed this feature, nor seen it used anywhere. The explanation is… terse, and the examples are… missing, AFAICT.

I would love to find a good write-up on how to use this feature. Failing that, I’ll happily write one and post it, if someone here can give me some examples and explanation of the intended use.

I’ll note in passing that this is not a syntax fragment that is very searchable, so please don’t RTFM me… :-)

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: [GENERAL] Bucardo syncrun
Next
From: Rob Sargent
Date:
Subject: Re: [GENERAL] query not scaling