Re: [SQL] delete from a using b in postgres 8.1.

2006-01-03 Thread Jaime Casanova
On 1/2/06, Peter Childs [EMAIL PROTECTED] wrote: a command such as delete from a using b where a.one=b.one and b.two='foo'; works fine in 8.1 but fails totally in 8.0 however delete from a where a.one=b.one and b.two='foo'; works fine in 8.0 and bellow but fails in 8.1 unless you have the

[SQL] delete from a using b in postgres 8.1.

2006-01-02 Thread Peter Childs
a command such as delete from a using b where a. and b.two='foo'; works fine in 8.1 but fails totally in 8.0 however delete from a where a. and b.two='foo'; works fine in 8.0 and bellow but fails in 8.1 unless you have the add_missing_from option set to true in 8.1 Even then it produces a