> The B'111...' and X'1F...' SQL92 literal syntax is limited to
> int4 sized literals. Any attempt to use an int8 sized literal
> > int4/32-bit word size fails. This makes it impossible to specify
> many int8 sized bit patterns as column default values. It makes
> it impossible to even insert > 32bit sized binary/hex values.
> Failure to support SQL92 literals for int8 types dramatically
> limits and/or complicates the use of int8 bit/nibble/byte composed
> values (bit fields, nibble/byte patterns, etc.)
The B'111...' and X'1F...' SQL92 literal syntax is not for integer types
at all. The upcoming version 7.1 will implement the BIT and BIT VARYING
types, which have virtually unlimited length.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/