Subject Re: [firebird-support] NUMERIC(18,0)
Author Helen Borrie
At 12:19 AM 19/09/2006, you wrote:
>When I make a field of the subject type, what is the maximum (largest)
>integer I can put into the field. The docs say there is a difference
>between signed and unsigned. So where do I "tell" firebird that I
>want this to be an unsigned field so I can get the max unsigned
>integer value into the field?
>If I only enter unsigned values into the field, and never once enter a
>signed value, does that mean I can just "keep going" and stuff in
>unsigned integer values and just "expect" FB to "know" that I want an
>"all unsigned" values field?

If you want to force the column (or domain) to accept only
non-negative values, you should constrain it to reject negative values, e.g.

create domain d_unsigned_big as bigint
check (value is null or value >= 0)