Re: Automatic casting - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Automatic casting
Date
Msg-id web-2828254@davinci.ethosmedia.com
Whole thread Raw
In response to Automatic casting  (Vicente Alabau Gonzalvo <vicente.alabau-gonzalvo@cgey.com>)
List pgsql-sql
Vicente,


> if I try nodo_fecha_activ<= 1044226800000 then it gives me this error
> ERROR:  Unable to identify an operator '<=' for types 'numeric' and
> 'double precision'

This is a known problem that will be fixed in a later version of
Postgres.  For now, you have to cast.

-Josh



pgsql-sql by date:

Previous
From: Ian Barwick
Date:
Subject: Re: 7.2 functions that return multiple result sets?
Next
From: "waimeng"
Date:
Subject: PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."