Message-Id: <5.1.0.14.0.20021008013840.01f5be78@mail.polonium.de>
Date: Tue, 08 Oct 2002 01:53:54 +0200
To: pgsql-sql@postgresql.org
From: Rafal Kedziorski <rafcio@polonium.de>
Subject: SQL Error
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

Hallo,

I have following table:

CREATE TABLE "scheduler_action" (
   "scheduler_action_id"  numeric(30) NOT NULL,
   "action_type"          numeric(4) NOT NULL,
   "priority"             numeric(4) NOT NULL,
   "referenced_id"        numeric(30) NOT NULL,
   "invocation_date"      numeric(30) NOT NULL,
   "is_done"              numeric(1) NOT NULL,
   PRIMARY KEY ("scheduler_action_id")
);

My quety look so:

select t0_o.scheduler_action_id from scheduler_action t0_o where 
t0_o.is_done = 0 and t0_o.invocation_date <= 1034033214921

And I get following error:

ERROR:  Unable to identify an operator '<=' for types 'numeric' and 'double 
precision'
         You will have to retype this query using an explicit cast

But if my query looks like:

select t0_o.scheduler_action_id from scheduler_action t0_o where 
t0_o.is_done = 0 and t0_o.invocation_date <= '1034033214921'

"invocation_date" is numeric with p=30 and s=0.


Best Regards,
Rafal