Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias
Date
Msg-id 20030411235924.I6598-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias  (Sergey Tikhonenko <tserge@dms.omskcity.com>)
List pgsql-bugs
On Sat, 12 Apr 2003, Sergey Tikhonenko wrote:

> When I work with MS SQL I write
>
> "UPDATE t1 SET value = 10 FROM test1 t1 INNER JOIN test2 ON
> t1.extid=test2.extid WHERE t1.id=1;"
>
> Why this not work in Postgresql?

We handle this extension to the spec differently.  Neither syntax is part
of SQL92/99 AFAICT and we made different assumptions about what behavior
was reasonable.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: heap_mark4update: (am)invalid tid
Next
From: Ennio-Sr
Date:
Subject: Re: Psql 'Expanded display (\x)' behaviour