Re: the '::' cast doesn't work in the FROM clause - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: the '::' cast doesn't work in the FROM clause
Date
Msg-id 4E5B5D1D02000025000407FF@gw.wicourts.gov
Whole thread Raw
In response to Re: the '::' cast doesn't work in the FROM clause  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
"Kevin Grittner" <Kevin.Grittner@wicourts.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

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: the '::' cast doesn't work in the FROM clause
Next
From: Tom Lane
Date:
Subject: Re: the '::' cast doesn't work in the FROM clause