X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A26A8D8B11 for ; Thu, 8 Sep 2005 21:43:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73620-10 for ; Fri, 9 Sep 2005 00:43:33 +0000 (GMT) Received: from lennier.cc.vt.edu (lennier.cc.vt.edu [198.82.162.213]) by svr1.postgresql.org (Postfix) with ESMTP id B8D19D8B3D for ; Thu, 8 Sep 2005 21:43:34 -0300 (ADT) Received: from dagger.cc.vt.edu (IDENT:mirapoint@evil-dagger.cc.vt.edu [10.1.1.11]) by lennier.cc.vt.edu (8.12.11/8.12.11) with ESMTP id j890hc3R021397 for ; Thu, 8 Sep 2005 20:43:38 -0400 Received: from zathras (zathras.cc.vt.edu [198.82.162.117]) by dagger.cc.vt.edu (MOS 3.6.4-CR) with ESMTP id ECB41721; Thu, 8 Sep 2005 20:43:37 -0400 (EDT) X-WebMail-UserID: miwalsh Date: Thu, 8 Sep 2005 20:43:37 -0400 From: miwalsh To: pqsql X-EXP32-SerialNo: 00002216 Subject: Numeric Columns Message-ID: <438F8BE9@zathras> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-Mailer: Infinite Mobile Delivery (Hydra) SMTP v3.62.01 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/98 X-Sequence-Number: 22645 I need to make a column that is capable of holding numeric values along with certain modifiers such as "<" or ">". The column needs to be searchable by numbers. For example, if someone searches for values lower than 10.0 the column should return the relevant values. However, the column needs to be able to hold values like "<0.05". Is this possible or do I have to change the schema?