On Nov 15, 2007 7:32 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> 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 avoidprogrammers 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
