strange update behavior

From: "Volkmar Herbst GCI" <herbst(at)gc-i(dot)de>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: strange update behavior
Date: 2011-04-13 19:59:01
Message-ID: 006b01cbfa15$41ec1800$c5c44800$@de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I did encounter a quite strange behavior during update which I did not
understand:

The following query updated table parcelle with only one entry for all rows:

update cadastre.parcelle

set code_unique = t2.code_unique from

cadastre.parcelle t1, cadastre.propriete t2

where t1.uoid = t2.uoidparcelle;

the next update query behaved as expected :

update cadastre.parcelle

set code_unique = t2.code_unique from

cadastre.parcelle t1, cadastre.propriete t2

where parcelle.uoid = t2.uoidparcelle;

Why do i have to reference table parcelle in the where clause?

Browse pgsql-sql by date

  From Date Subject
Next Message f vf 2011-04-14 10:56:51 Get id of a tuple using exception
Previous Message Anish Kejariwal 2011-04-13 19:03:51 Re: pass in array to function for use by where clause? how optimize?