Thread: bit datatype in 7.2.1

Hi,

I've upgraded from 7.1.3 to 7.2.1 and now I'm having problems with
the bit datatype. I used to do '0'::bit(20) to save some typing, but
it does not work anymore:
ERROR:  bit string length does not match type bit(20)

Is there a way to do it in version 7.2.1?

On Fri, 26 Apr 2002 13:50:15 +0400
"Joseph Artsimovich" <joseph_a@mail.ru> wrote:
> Hi,
>
> I've upgraded from 7.1.3 to 7.2.1 and now I'm having problems with
> the bit datatype. I used to do '0'::bit(20) to save some typing, but
> it does not work anymore:
> ERROR:  bit string length does not match type bit(20)
>
> Is there a way to do it in version 7.2.1?

Perhaps using BIT VARYING? See section 3.9 of the User's Guide.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC