X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 14BE0475A1F for ; Thu, 6 Feb 2003 15:31:02 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 514234758FE for ; Thu, 6 Feb 2003 15:31:01 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h16KTx5u015297; Thu, 6 Feb 2003 15:29:59 -0500 (EST) To: Vicente Alabau Gonzalvo Cc: pgsql-sql@postgresql.org Subject: Re: numeric when compared to literal In-reply-to: <3E3E6483.3060208@capgemini.es> References: <3E3E6483.3060208@capgemini.es> Comments: In-reply-to Vicente Alabau Gonzalvo message dated "Mon, 03 Feb 2003 13:45:55 +0100" Date: Thu, 06 Feb 2003 15:29:58 -0500 Message-ID: <15296.1044563398@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/133 X-Sequence-Number: 11531 Vicente Alabau Gonzalvo writes: > db=> select * from tipos where _numeric_ <= 2147483648; > ERROR: Unable to identify an operator '<=' for types 'numeric' and > 'double precision' 7.3 is more forgiving about this (although there's no free lunch --- some other cases are now less forgiving). regards, tom lane