Scott Klarenbach wrote:
>Is there a way to represent infinity in mysql?
>
>I've got a range field in my GUI, which is "> x"...
>
>if the user chooses this field, in the DB, I store it as:
>
>id | from | to | other
>2 | x | infinity | etc...
>
>this is because there are situations of "< x" and "bet
On Tuesday 29 March 2005 20:51, Scott Klarenbach wrote:
> Is there a way to represent infinity in mysql?
>
> I could make infinity default to 100,000,000 or some other number I
> know will never be reached, but it seems less elegant a solution...
probably not the best but you could have two fields
Is there a way to represent infinity in mysql?
I've got a range field in my GUI, which is "> x"...
if the user chooses this field, in the DB, I store it as:
id | from | to | other
2 | x | infinity | etc...
this is because there are situations of "< x" and "between x AND y",
so from and to is th
