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
>