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