Re: Check/unique constraint question - Mailing list pgsql-sql

From Karsten Hilbert
Subject Re: Check/unique constraint question
Date
Msg-id 20060305102942.GA7051@merkur.hilbert.loc
Whole thread Raw
In response to Re: Check/unique constraint question  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
List pgsql-sql
On Sun, Mar 05, 2006 at 12:02:58PM +0300, Nikolay Samokhvalov wrote:

> Unfortunately, at the moment Postgres doesn't support subqueries in
> CHECK constraints, so it's seems that you should use trigger to check
> what you need
The OP could also use a check constraint with a function if
everything (the context) but the value to check is known
beforehand or can be derived from it.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-sql by date:

Previous
From: sramsay@uga.edu
Date:
Subject: Re: functions in WHERE clause
Next
From: Tom Lane
Date:
Subject: Re: functions in WHERE clause