Re: Typing Records

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Typing Records
Date: 2010-08-24 15:06:27
Message-ID: FE6AD9D7-4362-4675-A5D0-44908B2C5272@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-08-24 15:06:53 Re: Typing Records
Previous Message Tom Lane 2010-08-24 15:06:02 Re: EXPLAIN doesn't show the actual function expression for FunctionScan