| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Anton Andreev *EXTERN*" <antonandreev(at)fmi(dot)uni-sofia(dot)bg>, <pgadmin-support(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] problem with check constraints |
| Date: | 2008-10-13 07:41:54 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C2029B5FB1@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
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/docs/8.3/static/sql-syntax-lexical.html#SQL-PRECEDENCE-TABLE
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2008-10-13 10:57:37 | Re: bug: Bit String Types |
| Previous Message | Guillaume Lelarge | 2008-10-11 13:08:22 | Re: Demande de la documentation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2008-10-13 07:51:41 | Re: how to remove the duplicate records from a table |
| Previous Message | Ivan Sergio Borgonovo | 2008-10-13 07:02:28 | Re: Drupal and PostgreSQL - performance issues? |