pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Numeric Columns
2+ messages / 2 participants
[nested] [flat]

* Numeric Columns
@ 2005-09-09 00:43 miwalsh <miwalsh@vt.edu>
  2005-09-09 01:09 ` Re: Numeric Columns Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: miwalsh @ 2005-09-09 00:43 UTC (permalink / raw)
  To: pgsql-sql

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?




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Numeric Columns
  2005-09-09 00:43 Numeric Columns miwalsh <miwalsh@vt.edu>
@ 2005-09-09 01:09 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-09-09 01:09 UTC (permalink / raw)
  To: miwalsh <miwalsh@vt.edu>; +Cc: pgsql-sql

miwalsh <miwalsh@vt.edu> writes:
> 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".

contrib/seg might do more or less what you're looking for, but none of
the standard datatypes will.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-09-09 01:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-09 00:43 Numeric Columns miwalsh <miwalsh@vt.edu>
2005-09-09 01:09 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox