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?
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? |