X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EE6D5475A37 for ; Mon, 3 Feb 2003 07:09:29 -0500 (EST) Received: from door.cgey.com (rpapar1.cgey.com [194.3.224.25]) by postgresql.org (Postfix) with ESMTP id 0B02B475A1E for ; Mon, 3 Feb 2003 07:09:29 -0500 (EST) Received: from pasteur2.capgemini.fr (capmail.capgemini.fr [10.67.1.90]) by door.cgey.com (8.12.1/8.11.3) with ESMTP id h13C9U7v027198 for ; Mon, 3 Feb 2003 13:09:31 +0100 (MET) Received: from pasteur.capgemini.fr (localhost [127.0.0.1]) by pasteur2.capgemini.fr (8.12.6/8.12.6) with ESMTP id h13CB7P1008510 for ; Mon, 3 Feb 2003 13:11:07 +0100 (MET) Received: from capgemini.es ([10.68.8.28]) by pasteur.capgemini.fr (8.12.6/8.12.6) with ESMTP id h13CB6GT008483 for ; Mon, 3 Feb 2003 13:11:06 +0100 (MET) Message-ID: <3E3E5BB5.1010105@capgemini.es> Date: Mon, 03 Feb 2003 13:08:21 +0100 From: Vicente Alabau Gonzalvo User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; ca; rv:1.2.1) Gecko/20021130 MultiZilla/v1.1.22 X-Accept-Language: ca-es MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Automatic casting Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/123 X-Sequence-Number: 11521 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'