insert into ...
select (a bunch of CASE statements specifying a subselect to use if the value of the attribute is null)...
from...(a messy JOIN)
in which one of the CASE contains a subselect which has an "Attribute not found" error when executed independently. However, the only way it manifests itself is through a NOT NULL constraint not being satisfied in the insert.
Should I spend any time trying to reproduce this in a simple case, or is there some known stupid way of making this happen?
Thanks!
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend