Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 78AE5475FD5 for ; Tue, 10 Dec 2002 22:08:20 -0500 (EST) Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net [194.217.242.80]) by postgresql.org (Postfix) with ESMTP id D53B6475FBA for ; Tue, 10 Dec 2002 22:08:19 -0500 (EST) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2) id 18LxEV-0007a2-0U; Wed, 11 Dec 2002 03:08:23 +0000 Received: from localhost ([127.0.0.1] ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian)) id 18LxEU-0004eq-00; Wed, 11 Dec 2002 03:08:22 +0000 Subject: Re: is numeric relational operator problem fixed in v7.3 From: Oliver Elphick To: jack Cc: pgsql-sql@postgresql.org In-Reply-To: <000e01c2a0c0$950c4710$1400a8c0@jac> References: <000e01c2a0c0$950c4710$1400a8c0@jac> Content-Type: text/plain Organization: LFIX Limited Message-Id: <1039576102.20146.143.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 11 Dec 2002 03:08:22 +0000 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/117 X-Sequence-Number: 10705 On Wed, 2002-12-11 at 02:54, jack wrote: > Does the following now works in postgreSQL v7.3? > > Select * > from a_table > where num1 >10; > > *** type of num1 is NUMERIC (12,2) It works -- Oliver Elphick LFIX Limited