On 18 Dec 2002 19:12:40 -0500
Greg Stark <gsstark@mit.edu> wrote:
>
> In the current situation we have a perfectly fine standard SQL query that runs
> fine on other databases but fails on postgres. And the only way to "fix" it
> for postgres is to add a non-standard cast to it that won't work on the other
> databases.
>
Most users on this list seem to prefer the Postgres specific odd variant of
a cast (::datatype). This will fail on all other databases of course, so
don't use it.
Use the SQL2 function CAST(att AS datatype) instead.
Suggestion: the cast variant '::' should be deprecated in the docs.
Christoph Dalitz