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

"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