Re: the '::' cast doesn't work in the FROM clause

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alexey Klyukin" <alexk(at)commandprompt(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: the '::' cast doesn't work in the FROM clause
Date: 2011-08-29 14:34:21
Message-ID: 4E5B5D1D02000025000407FF@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

> test=# select val from (select 'a' = 'a') as val;
> val
> -----
> (t)
> (1 row)

Also note the difference between a record and a scalar here. I
forgot to write it to return val as a scalar, which seems to be what
you're after. It should have been:

test=# select val from (select 'a' = 'a') as x(val);
val
-----
t
(1 row)

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-08-29 14:47:39 Re: the '::' cast doesn't work in the FROM clause
Previous Message Kevin Grittner 2011-08-29 14:29:33 Re: the '::' cast doesn't work in the FROM clause