On 09/18/2014 10:40 PM, Marko Tiikkaja wrote:
> 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
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: