Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7npc-00008e-0e for pgsql-general@arkaria.postgresql.org; Fri, 09 Aug 2013 14:38:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V7npb-0006TE-8u for pgsql-general@arkaria.postgresql.org; Fri, 09 Aug 2013 14:38:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7npS-0006Fe-Bn for pgsql-general@postgresql.org; Fri, 09 Aug 2013 14:38:10 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7npL-0004Ct-7B for pgsql-general@postgresql.org; Fri, 09 Aug 2013 14:38:09 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1V7npJ-0003Dd-HU for pgsql-general@postgresql.org; Fri, 09 Aug 2013 07:38:01 -0700 Date: Fri, 9 Aug 2013 07:38:01 -0700 (PDT) From: David Johnston To: pgsql-general@postgresql.org Message-ID: <1376059081534-5766960.post@n5.nabble.com> In-Reply-To: <1376058047506-5766954.post@n5.nabble.com> References: <1376058047506-5766954.post@n5.nabble.com> Subject: Re: Here is my problem MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.8 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general