On 2014-09-18 10:29 PM, Vik Fearing wrote:
On 09/18/2014 10:16 PM, Hannu Krosing wrote:
I guess it proves (a little) that WITH is the right place to do these
kind of things ...


I've been wanting this syntax for a few years now, so I certainly vote
for it.

I've also been wanting do to something like:

  WITH mytyp AS (a int, b int, c int)
  SELECT (tup).* FROM
  (
    SELECT CASE WHEN .. THEN ROW(1,2,3)::mytyp
            WHEN .. THEN ROW(2,3,4)
            ELSE ROW (3,4,5) END AS tup
    FROM ..
  ) ss


.marko


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to