Re: 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 and unnest but i want in this format
>
> pls help..

Use the

INSERT INTO tbl (...)
SELECT *
FROM src

form of insert to build and insert an entire dynamic result.

DavidJ.

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