Postgres Pro
Downloads
Home   >   mailing lists

CREATE DOMAIN with referential integrity - Mailing list pgsql-general

From regme please
Subject CREATE DOMAIN with referential integrity
Date
Msg-id 446c7e870808200707p49305450if32a56254807396e@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
HI all.
Is there a way to CREATE a DOMAIN in v8.3 with a CHECK() predicate to ensure the value is in a dictionary table?
Of course, I already know the trivial and ugly solution with a (PL/Pg)SQL lookup function.

Thanks.

pgsql-general by date:

Previous
From: "Matthew Pettis"
Date:
Subject: Re: Fwd: Restarting with pg_ctl, users, and passwords.
Next
From: Adrian Klaver
Date:
Subject: Re: schema name in SQL statement.