Here is my problem

From: Basavaraj <basava247(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Here is my problem
Date: 2013-08-09 14:20:47
Message-ID: 1376058047506-5766954.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paula Kirsch 2013-08-09 14:27:25 bi-directional syncing help request
Previous Message Tom Lane 2013-08-09 14:20:10 Re: plpgsql FOR LOOP CTE problem ?