Operator to compare numeric and double precision

Поиск
Список
Период
Сортировка
От Terry Yapt
Тема Operator to compare numeric and double precision
Дата
Msg-id 1035720158.81bd100pgsql@technovell.com
обсуждение исходный текст
Список 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
getan 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
becausein spite of I am passing -1- to the parameter, Delphi is converting it to 1.00000. 

Thanks in advance...


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: index not scanned
Следующее
От: Darko Prenosil
Дата:
Сообщение: Re: COMMAND_OK for PL/pgSQL?