Hello,
The following statement produces an error message in PostgreSQL 8.4 - 9.2 (=
head):
postgres=3D# select val from random()::integer as val;
ERROR: syntax error at or near "::"
LINE 1: select val from random()::integer as val;
The same statement rewritten with CAST AS works as expected:
^
postgres=3D# select val from CAST(random() as integer) as val;
val
-----
1
(1 row)
The '::' cast works normally when used in a target list:
postgres=3D# select random()::integer as val;
val
--------
1
(1 row)
The documentation says these casts are equivalent, so either that's wrong, =
or this is a bug.
The target OS is Mac OS X 10.7.1 with llvm-gcc-4.2 used as a compiler.
--
Alexey Klyukin http://www.commandprompt.com
The PostgreSQL Company =96 Command Prompt, Inc.