Here is my problem - Mailing list pgsql-general

From Basavaraj
Subject Here is my problem
Date
Msg-id 1376058047506-5766954.post@n5.nabble.com
Whole thread Raw
Responses need help  (Basavaraj <basava247@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: Don Parris
Date:
Subject: Re: How To Install Extension Via Script File?
Next
From: Jeff Janes
Date:
Subject: Re: How to avoid Force Autovacuum