Re: [pgadmin-support] [GENERAL] problem with check constraints

2008-10-13 Thread Albe Laurenz
Anton Andreev wrote: > When I create a check constraint in PgAdmin3 1.8.4 on a Postgresql > 8.3.3: ((A and B) or (C and D)) > I get with create script: (A and B or C and D) which is wrong. No, it isn't - both are the same. AND has higher operator precedence than OR, see http://www.postgresql.org

Re: [pgadmin-support] bug: Bit String Types

2008-10-13 Thread Dave Page
On Thu, Oct 9, 2008 at 1:45 PM, Pfuetz, Michael <[EMAIL PROTECTED]> wrote: > Hello, > > i think there is bugs in pgadmin: > CREATE TABLE test_bit > ( > id text NOT NULL, > byte bit(8) NOT NULL, > CONSTRAINT test_bit_pkey PRIMARY KEY (id) > ) > WITHOUT OIDS; > ALTER TABLE test_bit OWNER TO ass