| Lists: | pgsql-sql |
|---|
| From: | Vicente Alabau Gonzalvo <vicente(dot)alabau-gonzalvo(at)cgey(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Automatic casting |
| Date: | 2003-02-03 12:08:21 |
| Message-ID: | 3E3E5BB5.1010105@capgemini.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
Is there any way of doing
nodo_fecha_activ<= 1044226800000::numeric
without casting?
nodo_fecha_activ is numeric
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'
| 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 |
| 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