Re: [GENERAL] Elegant copy of a row using PL

2007-01-16 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > On 1/16/07, richard lavoie <[EMAIL PROTECTED]> wrote: >> 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 methodol

Re: [GENERAL] Elegant copy of a row using PL

2007-01-16 Thread Merlin Moncure
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

[GENERAL] Elegant copy of a row using PL

2007-01-16 Thread richard lavoie
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? Th