[GENERAL] 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.. -- V

Re: [GENERAL] Here is my problem

Basavaraj wrote > 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 an