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?

Thank you very much
Richard
--
"Feel free" - 5 GB Mailbox, 50 FreeSMS/Monat ...
Jetzt GMX ProMail testen: http://www.gmx.net/de/go/promail

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On 1/16/07, richard lavoie <richard_lavoie@gmx.de> 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

"Merlin Moncure" <mmoncure@gmail.com> writes:
> On 1/16/07, richard lavoie <richard_lavoie@gmx.de> 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 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.

Also, I think in 8.2 you could use a record variable in plpgsql.

declare r record;

select * into r from src where ...;
r.foo = whatever;
r.bar = whatever;
insert into dest values(r.*);

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/