Re: Anonymous code block with parameters

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