On 5 Dec 2013, at 06:10, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew Dunstan <andrew@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
rightwhere 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