Here is my problem

Now i want to insert data to the table....
the format should be

id | marks
----------
1  |50
1  |30
1  |30
....
....
2 |...
....

the actual query is

insert into table(id,marks) values(1,unnest(array[marks]))


But we should not use array and unnest but i want in this format

pls help..



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Here-is-my-problem-tp5766954.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.