pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Storing a range of numbers
3+ messages / 3 participants
[nested] [flat]
* Re: Storing a range of numbers
@ 2004-02-06 13:56 CoL <col@mportal.hu>
2004-02-06 20:17 ` Re: Storing a range of numbers Chris Fisher <essensus@comcast.net>
0 siblings, 1 reply; 3+ messages in thread
From: CoL @ 2004-02-06 13:56 UTC (permalink / raw)
To: pgsql-sql
hi,
Chris Fisher wrote:
> Hi,
>
> Is it possible to store a numeric range in a row and query for it, or
> would I have to use two rows containing the minimum and maximum limits?
or you can have one column, with array type. than the first element is
the min value the second is the max:) Question is: is it good for your
applications or not, how woud you use it, etc.
C.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Storing a range of numbers
2004-02-06 13:56 Re: Storing a range of numbers CoL <col@mportal.hu>
@ 2004-02-06 20:17 ` Chris Fisher <essensus@comcast.net>
2004-02-07 20:53 ` Re: Storing a range of numbers Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Chris Fisher @ 2004-02-06 20:17 UTC (permalink / raw)
To: pgsql-sql
CoL wrote:
> or you can have one column, with array type. than the first element is
> the min value the second is the max:) Question is: is it good for your
> applications or not, how woud you use it, etc.
I thought about using an array but it seems overly complicated for what
I'm doing. Two rows will work fine ... a numeric range type seemed
obvious at the time so I figured I just missed it in the documentation
or something.
Thanks for the reply.
Chris
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Storing a range of numbers
2004-02-06 13:56 Re: Storing a range of numbers CoL <col@mportal.hu>
2004-02-06 20:17 ` Re: Storing a range of numbers Chris Fisher <essensus@comcast.net>
@ 2004-02-07 20:53 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-02-07 20:53 UTC (permalink / raw)
To: Chris Fisher <essensus@comcast.net>; +Cc: pgsql-sql
Chris Fisher <essensus@comcast.net> writes:
> ... a numeric range type seemed
> obvious at the time so I figured I just missed it in the documentation
> or something.
The "seg" datatype implemented by contrib/seg might be what you want.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-02-07 20:53 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-06 13:56 Re: Storing a range of numbers CoL <col@mportal.hu>
2004-02-06 20:17 ` Chris Fisher <essensus@comcast.net>
2004-02-07 20:53 ` 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