Postgres Pro
Downloads
Home   >   mailing lists

Re: numeric when compared to literal - Mailing list pgsql-sql

From Tom Lane
Subject Re: numeric when compared to literal
Date
Msg-id 15296.1044563398@sss.pgh.pa.us
Whole thread Raw
In response to numeric when compared to literal  (Vicente Alabau Gonzalvo <vicente.alabau-gonzalvo@cgey.com>)
List pgsql-sql
Tree view 
Vicente Alabau Gonzalvo <vicente.alabau-gonzalvo@cgey.com> writes:
> db=> select * from tipos where _numeric_ <= 2147483648;
> ERROR:  Unable to identify an operator '<=' for types 'numeric' and 
> 'double precision'

7.3 is more forgiving about this (although there's no free lunch ---
some other cases are now less forgiving).
        regards, tom lane

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: changing referential integrety action on existing table
Next
From: Ian Barwick
Date:
Subject: Re: 7.2 functions that return multiple result sets?