On 1/16/07, richard lavoie <[EMAIL PROTECTED]> wrote:
Hi!
I'm not sure about the English terminology for that so I'm sorry if I made a
mistake on the subject and on this message.
I've a table with 50 colums. I want to copy a certain row using PL and change
only 2 values. The way to do it with insert is to long. Is there any other
elegant way?
the basic methodology is to:
insert select into a scratch table;
update scratch table;
insert select back into real_table;
scratch can be a persistent table (remember to truncate it) or a temp
table. if it is a temp, remember to create it before you call your pl
for the first time in a session.
merlin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
