Re: Strange Update-Bug in postgres (is it a feature?) ?!

On Mon, 15 Apr 2002, Tarabas wrote:

> Is this a bug or a feature:
>
> When I try an update like this
> "update mail set mail.mailread=1 where mail.mail_id=123" I get the Error
> "Error while executing query parse error near '.'"
>
> Then I try
>
> "update mail set mailread=1 where mail.mail_id=123" and it works fine ...

I believe this is what the SQL92 standard asks for. It seems to want
<column name> = <update source> rather than something like
<column reference> = <update source>

My memory is rather flaky but I vaguely remember a recent discussion on
something similar (maybe column names in insert lists?) that made it sound
like it might be possible to convince a change, but it would probably have
to properly error on cases where the names didn't match properly.