On Nov 15, 2007 7:32 PM, Albe Laurenz <[EMAIL PROTECTED]> wrote: > > You want to have a "conditional" foreign key reference that checks > against different tables depending on a "type" field, right? > > For complicated conditions like this, you could use a > BEFORE INSERT trigger that throws an error when the condition > is violated.
That we do. My query is to put a check on select queries to avoid programmers not using all the necessary conditions. Thanks and regards, Ma Sivakumar -- மா சிவகுமார் எல்லோரும் எல்லாமும் பெற வேண்டும் http://masivakumar.blogspot.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq