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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to