Re: Checking of constraints via subqueries? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Checking of constraints via subqueries?
Date
Msg-id 20050217180358.GA26697@winnie.fuhr.org
Whole thread Raw
In response to Checking of constraints via subqueries?  (Wolfgang Drotschmann <drotschm@fgan.de>)
Responses Re: Checking of constraints via subqueries?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Thu, Feb 17, 2005 at 04:37:43PM +0100, Wolfgang Drotschmann wrote:

> "...CHECK expressions cannot contain subqueries nor refer to
>  variables other than VALUE."

In experiments I've defined a domain's CHECK expression to call a
function that makes queries.  It worked in simple tests; I don't
know if it'll work in the general case.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Robby Russell
Date:
Subject: Re: Suggestions on a good Postgresql 7.4 or 8.0 book
Next
From: John Allgood
Date:
Subject: Re: Problems compiling 7.4.6 src rpms