On 5 Dec 2013, at 06:10, Tom Lane <t...@sss.pgh.pa.us> wrote: > Andrew Dunstan <and...@dunslane.net> writes: >>>> Well I guess we could say something like: >>>> >>>> FOREIGN KEY (a-col) WHERE (a-condition) REFERENCES b(b-col) WHERE >>>> (b-condition) >>>> > > I like what you have above.
Yeah. Given both the apparent ambiguity of the current placement, and the fact that the current placement would be right where you’d put a where clause on the referenced table, that’s the only sane way to do it. And it’s not so bad. Cheers Tom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers