Subject RE: Re: [firebird-support] Firebird, SQL Dialect 1 and NUMERIC(18,2)

Ok. Can I do a select statement, where I limit to those containing INF value?

I seem to fail to create to correct SQL


---In, <mark@...> wrote:

On 25 Nov 2013 02:54:16 -0800, <Michael.Vilhelmsen@...> wrote:

> What does INF mean?
> How can I create SQL to limit by value INF?

INF = infinity. AFAIK a NUMERIC(18,2) in dialect 1 is based on a DOUBLE
PRECISION instead of BIGINT (INT64) as in dialect 3, so infinity is a valid