| 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: | Whole Thread | Raw Message | 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? |