From: | Guyren Howe <guyren(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Combing row returning functions using "ROWS FROM"? |
Date: | 2017-10-27 00:29:10 |
Message-ID: | B21959E8-80D7-4C68-927F-1406B2BE0AA9@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <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… :-)
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2017-10-27 01:07:25 | Re: query not scaling |
Previous Message | Greg Sabino Mullane | 2017-10-26 22:43:57 | Re: Bucardo syncrun |