Tom,

> This is absolutely NOT an error.  iddomain in the subquery is a
> legitimate outer reference, if it's not otherwise known in the subquery.
> There is no clause in the SQL spec that says that outer references are
> invisible in any context ... even if it means you just deleted your
> whole table, which is what I think will happen here...

Yup, that's what happened.

Wasn't sure.    We're OK then.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to