Barry Lind <barry(at)xythos(dot)com> writes:
> In testing Neil's PREPARE/EXECUTE patch on my test query, I found the
> parser complains that this query is not valid when using current
> sources. The error I get is:
> psql:testorig.sql:1: ERROR: JOIN/ON clause refers to "xf2", which is
> not part of JOIN
Hmm. I have an open bug with sub-SELECTs inside a JOIN, but this
example doesn't look like it would trigger that.
> I think the sql is valid (at least it has worked in 7.1 and 7.2). Is
> this a bug?
Dunno. Give me a test case (and no, I am *not* going to try to
reverse-engineer table schemas from that SELECT).
regards, tom lane