:38:58 +1000
Subject: [SQL] funny update, say update 1, updated 1 added 2nd.
> I have been having some trouble with a particular table view. An UPDATE
> command is not only changing the applicable record it is also creating a
> new record as well.
>
> wholesale=# select * from acc
I have been having some trouble with a particular table view. An UPDATE
command is not only changing the applicable record it is also creating a
new record as well.
wholesale=# select * from accounts_supplier;
id | name | contact | addr| addr2 | town |
postcode | st