check constraint

From: erwan ancel <erwan(dot)ancel(at)free(dot)fr>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: check constraint
Date: 2003-06-02 08:52:00
Message-ID: 1054543920.5523.8.camel@brisedorient
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I would like to know if it is possible to set "complex" constraints on
databases such as:

A->B means that in table A, each record references a record of table B
(or NULL)

so we have:

A->B
C->B
D->C
D->A
constraint: for one record of D, D->A->B = D->C->B

Hope it is clear enough.

Erwan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2003-06-02 09:16:00 Re: implicit abort harmful?
Previous Message Nigel J. Andrews 2003-06-02 08:48:27 PostgreSQL presentation in France