> Date: Sun, 27 Oct 2002 13:02:38 +0100
> From: Terry Yapt <pgsql@technovell.com>
>
> Are there any operator to compare numeric with double precision ?
>
Try the SQL-Function CAST (its part of the SQL2 standard), eg.
... WHERE doublefield = (CAST numericfield AS DOUBLE) ...
I don't know whether ODBC supports SQL-Functions directly; you will
probably need to use the "PASSTHROUGH" parameter.
Hope this helps,
Christoph Dalitz