Re: copy rows

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
>