Horton

Re: Anonymous code block with parameters

Marko Tiikkaja <marko@joh.to>

View thread View on postgr.es
From: Marko Tiikkaja <marko@joh.to>
To: Vik Fearing <vik.fearing@dalibo.com>, Hannu Krosing <hannu@2ndQuadrant.com>, Pavel Stehule <pavel.stehule@gmail.com>, Andres Freund <andres@2ndquadrant.com>
Cc: Heikki Linnakangas <hlinnakangas@vmware.com>, Craig Ringer <craig@2ndquadrant.com>, Kalyanov Dmitry <kalyanov.dmitry@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2014-09-18T20:40:28Z
Lists: pgsql-hackers 
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