Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7qOr-0008Db-Ap for pgsql-general@arkaria.postgresql.org; Fri, 09 Aug 2013 17:22:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V7qOq-0002D4-Mp for pgsql-general@arkaria.postgresql.org; Fri, 09 Aug 2013 17:22:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7nYi-0004uL-Ga for pgsql-general@postgresql.org; Fri, 09 Aug 2013 14:20:52 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7nYe-0003v2-RJ for pgsql-general@postgresql.org; Fri, 09 Aug 2013 14:20:52 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1V7nYd-0001wX-HV for pgsql-general@postgresql.org; Fri, 09 Aug 2013 07:20:47 -0700 Date: Fri, 9 Aug 2013 07:20:47 -0700 (PDT) From: Basavaraj To: pgsql-general@postgresql.org Message-ID: <1376058047506-5766954.post@n5.nabble.com> Subject: Here is my problem MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.2 (+) 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 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general