BUG #4515: UPDATE strange behavior

From: "xtron" <xtronz(at)yandex(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4515: UPDATE strange behavior
Date: 2008-11-06 12:05:23
Message-ID: 200811061205.mA6C5NGj021983@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4515
Logged by: xtron
Email address: xtronz(at)yandex(dot)ru
PostgreSQL version: 8.3.5
Operating system: Debian GNU/Linux
Description: UPDATE strange behavior
Details:

IMHO this is strange behavior:

create table a1(id int, value int);
create table a2(id int, value int);

this is work:
update a1 set value = a2.value from a2 where a1.id = a2.id;

this is NOT work:
update a1 set a1.value = a2.value from a2 where a1.id = a2.id;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rodriguez Fernando 2008-11-06 12:28:51 Re: BUG #4514: Pi division error
Previous Message Traci Sumpter 2008-11-06 06:56:07 BUG #4514: Pi division error