Skip site navigation (1) Skip section navigation (2)

Re: bit datatype in 7.2.1

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Joseph Artsimovich" <joseph_a(at)mail(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: bit datatype in 7.2.1
Date: 2002-04-26 16:47:46
Message-ID: 20020426124746.6e9976f8.nconway@klamath.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, 26 Apr 2002 13:50:15 +0400
"Joseph Artsimovich" <joseph_a(at)mail(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

pgsql-general by date

Next:From: Andrew GouldDate: 2002-04-26 16:49:29
Subject: Re: requesting features in PostgreSQL
Previous:From: Roderick A. AndersonDate: 2002-04-26 16:25:43
Subject: PG back-ended, Web based, QUIZ app.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group