Message-ID: <4210AFEF.412532E8@rodos.fzk.de>
Date: Mon, 14 Feb 2005 15:04:31 +0100
From: Christoph Haller <ch@rodos.fzk.de>
MIME-Version: 1.0
To: drdani@mazsola.iit.uni-miskolc.hu
Cc: pgsql-sql@postgresql.org
Subject: Re: copy rows
References: <2989532e0502082245c7e50ea@mail.gmail.com>
	<Pine.LNX.4.61.0502090849260.16831@mazsola.iit.uni-miskolc.hu>
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

I have not been too deep into 8.0, but AFAIK from 
the 7.x releases, the only way to do things like 
you describe, is do it the hard way: 

use SELECT INTO to get the field values you want
into variables
modify the necessary field values
do the INSERT via Executing A Dynamic Command

Inserting a record type variable has been brought up 
before, but IIRC this is not possible. 
You may like to search the archives. 

HTH
Regards, Christoph 


drdani@mazsola.iit.uni-miskolc.hu wrote:
> 
> Hi,
> 
> What is the simplest solution in plpgsql to copy some rows in a table?
> 
> I would like to do something like:
> 
> select some rows
>     do for each row
>        skip serial field  \
>        modify one field   |-- what is the simplest way for this?
>        insert as new row  /
> 
> Is it possible to insert a record type variable? If yes, how to skip a
> field?
> 
> Daniel
>