Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Sergey Tikhonenko <tserge(at)dms(dot)omskcity(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #938: Wrong UPDATE if exist INNER JOIN and alias
Date: 2003-04-12 07:02:58
Message-ID: 20030411235924.I6598-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ennio-Sr 2003-04-12 14:12:10 Re: Psql 'Expanded display (\x)' behaviour
Previous Message Tom Lane 2003-04-12 05:19:26 Re: heap_mark4update: (am)invalid tid