Re: problem with check constraints

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: Anton Andreev <antonandreev(at)fmi(dot)uni-sofia(dot)bg>
Cc: pgadmin-support(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: problem with check constraints
Date: 2008-10-09 07:50:39
Message-ID: 48EDB7CF.2030106@nsoft.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-general

Hello, Anton

Its ok, because conjunction (AND) has priority over disjunction (OR) so
((A and B) or (C and D)) = (A and B or C and D)

Anton Andreev rašė:
> Hi,
>
> 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.
>
> Please help.
>
> Cheers,
> Anton
>
>

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Pfuetz, Michael 2008-10-09 12:45:50 bug: Bit String Types
Previous Message Anton Andreev 2008-10-08 20:08:14 problem with check constraints

Browse pgsql-general by date

  From Date Subject
Next Message Galland Gregoire 2008-10-09 08:37:51 Run postgresql engine in readonly mode?
Previous Message Artacus 2008-10-09 07:40:31 psql variable quoting