Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3ADE2475AE4
	for <pgsql-sql@postgresql.org>; Thu, 10 Oct 2002 07:12:13 -0400 (EDT)
Received: from matrix.gatewaynet.com (unknown [217.19.69.50])
	by postgresql.org (Postfix) with ESMTP id 1628B4762C4
	for <pgsql-sql@postgresql.org>; Thu, 10 Oct 2002 07:12:10 -0400 (EDT)
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g9ABNNk28153;
	Thu, 10 Oct 2002 14:23:23 +0300
Date: Thu, 10 Oct 2002 14:23:23 +0300 (EEST)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: rafcio@polonium.de, <pgsql-sql@postgresql.org>
Subject: Re: SQL Error
In-Reply-To: <3DA54424.B48015F8@rodos.fzk.de>
Message-ID: <Pine.LNX.4.44.0210101421420.28144-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/132
X-Sequence-Number: 9849


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

seems to work in

 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96

The reason that this query worked in hpux without the explicit
casting is maybe hpux runs on a 64-bit architecture processor

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr