Re: Automatic casting

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Vicente Alabau Gonzalvo <vicente(dot)alabau-gonzalvo(at)cgey(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Automatic casting
Date: 2003-02-06 23:02:40
Message-ID: web-2828254@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message waimeng 2003-02-07 07:53:18 PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."
Previous Message Ian Barwick 2003-02-06 22:53:55 Re: 7.2 functions that return multiple result sets?