Operator to compare numeric and double precision

From: Terry Yapt <pgsql(at)technovell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Operator to compare numeric and double precision
Date: 2002-10-27 12:02:38
Message-ID: 1035720158.81bd100pgsql@technovell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

It is a basic question (I hope it).

Are there any operator to compare numeric with double precision ?

It is something relative to Delphi/ODBC stuff. I cannot cast neither numeric nor double precision operands. I must to get an operator to compare something like this:
-*- numeric = double precision
-*- 1 = 1.00000 (and get TRUE)..

Numeric type is identified by Delphi with float type (independent of its ZERO precision), and here is the problem because in spite of I am passing -1- to the parameter, Delphi is converting it to 1.00000.

Thanks in advance...

Browse pgsql-general by date

  From Date Subject
Next Message freenet 2002-10-27 13:33:19 ODBC
Previous Message Martijn van Oosterhout 2002-10-27 10:56:57 Re: index not scanned