Re: [BUGS] update the same tuple in one command twice

2010-03-16 Thread Tom Lane
"Kevin Grittner" writes: > "terry" <94487...@qq.com> wrote: >> In one command, why can we update the same tuple for twice? >> TEST=# update t1 set a = t2.d from t2 where a=t2.c; >> UPDATE 1 > It says it updated it once. Why do you think otherwise? I think maybe the OP meant to type "why *can

Re: [BUGS] update the same tuple in one command twice

2010-03-16 Thread Kevin Grittner
"terry" <94487...@qq.com> wrote: > In one command, why can we update the same tuple for twice? > TEST=# update t1 set a = t2.d from t2 where a=t2.c; > UPDATE 1 It says it updated it once. Why do you think otherwise? > And the result is not predicated!! When you select multiple rows witho

[BUGS] update the same tuple in one command twice

2010-03-16 Thread terry
In one command, why can we update the same tuple for twice? And the result is not predicated!! Welcome to psql 8.3.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate wit