Re: [SQL] Storing a range of numbers

2004-02-07 Thread Tom Lane
Chris Fisher <[EMAIL PROTECTED]> 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 --

Re: [SQL] Storing a range of numbers

2004-02-07 Thread CoL
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

Re: [SQL] Storing a range of numbers

2004-02-07 Thread Chris Fisher
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

[SQL] techniques for manual ordering of data ?

2004-02-07 Thread Peter Galbavy
I tried googling, but the keywords here are so general, that I couldn't find much useful. I am looking for reommendations on how to build an ordered list of media (in this case photographs) in a particular "context". What I have - which I have somewhat simplified maually - is: CREATE TABLE contex