Re: Typing Records - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Typing Records
Date
Msg-id FE6AD9D7-4362-4675-A5D0-44908B2C5272@kineticode.com
Whole thread Raw
In response to Re: Typing Records  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
On Aug 23, 2010, at 11:24 PM, Joe Conway wrote:

> Maybe something like this?
>
> select cmp_ok(a,b,c)
> from
> (
>    values('1.2.2'::varchar,  '='::text, '1.2.2'::varchar),
>          ('1.2.23', '=', '1.2.23'),
>          ('1.2.42', '=', '1.2.32')
> ) as ss(a, b, c);
> cmp_ok
> --------
> t
> t
> f
> (3 rows)

Yes, exactly what I wanted. I knew I was missing something subtle (I had too many parens when I did it). Thanks Joe!

Best,

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: EXPLAIN doesn't show the actual function expression for FunctionScan
Next
From: "David E. Wheeler"
Date:
Subject: Re: Typing Records