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

On Aug 29, 2011, at 5:02 PM, Kevin Grittner wrote:

> Alexey Klyukin <alexk@commandprompt.com> wrote:
>=20
>> Function calls can appear in the FROM clause. (This is especially
>> useful for functions that return result sets, but any function can
>> be used.) This acts as though its output were created as a
>> temporary table for the duration of this single SELECT command.
>=20
> It doesn't say that operators which provide equivalent functionality
> to functions can also be used.

I agree, but why is it possible to use the type casting with CAST there? Do=
esn't this break the promise of equivalency between the 'CAST .. ' and '::'?

select val from CAST(random() as integer) as val;
 val=20
-----
   1
(1 row)

--
Alexey Klyukin        http://www.commandprompt.com
The PostgreSQL Company =96 Command Prompt, Inc.