Re: delete from a using b in postgres 8.1.

On 1/2/06, Peter Childs <peterachilds(at)gmail(dot)com> 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
> add_missing_from option set to true in 8.1
> Even then it produces a nasty warning.
>

it will not break anything because you can set this flag in the
VERSION/PLATFORM COMPATIBILITY section of postgresql.conf

> This can break tones of clients admittedly the work around is quick but not
> particularly neat. What do the other sql database do and is this just
> another inconstancy in SQL?
>
> I realise this was done to fix a bug but its a nasty sitting there that many
> client developers are going to miss it before it goes back to the end user.
> I also don't think this has been made particularly clear in changes.
>
> Peter Childs
>

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)