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.
