Re: UPDATE sql question
От | Ron Johnson |
---|---|
Тема | Re: UPDATE sql question |
Дата | |
Msg-id | 1059747555.7505.587.camel@haggis обсуждение исходный текст |
Ответ на | UPDATE sql question (Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>) |
Ответы |
Re: UPDATE sql question
|
Список | pgsql-general |
On Mon, 2003-07-28 at 03:24, Andrei Verovski wrote: > Hi, > > What exactly will happen if UPDATE sql statement instructs to update > some columns with the same values as already in the database? Will > Postgres update only different values or it will simply modify all > columns listed in UPDATE sql? You mean this: template1=# create table foo (f1 integer); CREATE TABLE template1=# insert into foo values (1); INSERT 16992 1 template1=# insert into foo values (2); INSERT 16993 1 template1=# insert into foo values (1); INSERT 16994 1 template1=# insert into foo values (3); INSERT 16995 1 template1=# select * from foo; 1 2 1 3 template1=# update foo set f1 = 1 where f1 = 1; UPDATE 2 template1=# select * from foo; 2 3 1 1 Looks like it does what you tell it to do... -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: