William Robertson wrote:
> Ranko.Mosic_at_gmail.com wrote:
>
>>Question was very clear - Tom Kyte and some other people understood and
>>immediatelly responded.
>>Sign of bad IT person: when presented with question/challenge they ask
>>" Why ? ( do you want to do it; would there be something like it )
>>..."; or answer is not reply to your question, but something you know
>>about ( not necessarily related to the question )
>>I was just asked if something like this exists, and it turns out 10g
>>has some constants like that,
>>like above mentioned BINARY_DOUBLE_INFINITY. So problem presented here
>>is not that unusual.
>>Fact that you don't know something, didn't think of something, or can't
>>strech your brain a little doesn't have to provoke
>>inelegant/mediocre/attacking responses.
>>And constant can be assigned a value.
>>
>>Regards, Ranko.
>
>
> Well I'm still intrigued about what the point of it might be. The
> examples in the documentation are not much help.
> "WHERE salary < BINARY_FLOAT_INFINITY"
> would seem to be the same as
> "WHERE salary IS NOT NULL".
Anyone using BINARY_FLOAT for salary information might have more
issues than just the use of a constant.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Dec 04 2005 - 14:09:12 CST
