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
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 without
Kevin Grittner kevin.gritt...@wicourts.gov 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