delete from a using b in postgres 8.1.

a command such as<br /><br /> delete from a using b where a.one=b.one and b.two='foo';<br /><br /> works fine in 8.1
butfails totally in 8.0 however<br /><br /> delete from a where a.one=b.one and b.two='foo';<br /><br /> works fine in
8.0and bellow but fails in 8.1 unless you have the add_missing_from option set to true in 8.1 <br /> Even then it
producesa nasty warning.<br /><br /> This can break tones of clients admittedly the work around is quick but not
particularlyneat. What do the other sql database do and is this just another inconstancy in SQL?<br /><br /> I realise
thiswas done to fix a bug but its a nasty sitting there that many client developers are going to miss it before it goes
backto the end user. I also don't think  this has been made particularly clear in changes.<br /><br /> Peter Childs<br
/>