Need a sample Postgre SQL script

Hi All,

I'm kind of new to Postgre and I need some advice.
I have the following table.
metadata (value:integer , field:integer , mydate:text)

given below is a sample record from that.
( 2 , 16 , Augest 2009)

I need a script that will read the above table and for each such row it will
insert two rows as below.

( 2 , 91 , Augest )
( 2 , 86 , 2009 )

16, 91 and 86 are static values. *value and field together* creates the
primary key.

I could figure out and write the logic for this. I only need a little bit
similar sample script so that I can figure out Postgre syntax.
Like
- Loop syntax to through all the rows return by a select *
- How to assign that value to a parameter
- using that parameter in the Insert statement
- etc ...

Thanks,
Dhanushka.