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
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