Hi ,
I have an array that need to be split into table columns.
Ex:
test_array('{"( 1,2,3,4,5)","(1 0,20,30,40,50)" }')
test_table
col1 col2 col3 col4 col5
1 2 3 4 5
10 20 30 40 50
vardhangiri
Last Activity: Jun 10 '10, 06:30 AM
Joined: Jun 10 '10
Location:
-
Split array data and fill the coulmns in the table
-
Exception handling in postgresql
HI,
Im new to postgresql i have written two procedures.proc edure1 takes input from the user array of table objects and loops over them and for each row it calls the second procedure2 where the acutal filling of tables happen.
My problem here is if the user passes 10 record and if record 5 fails then all the other records should be posted to the table.
No activity results to display