Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37990=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1XrtZ9-00077O-0p
 for pgsql-sql@arkaria.postgresql.org; Fri, 21 Nov 2014 19:08:23 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37990=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1XrtZ8-0004HQ-Hh
 for pgsql-sql@arkaria.postgresql.org; Fri, 21 Nov 2014 19:08:22 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <oliveiros.cristina@gmail.com>)
 id 1XrtZ7-0004HJ-Qv
 for pgsql-sql@postgresql.org; Fri, 21 Nov 2014 19:08:21 +0000
Received: from mail-wi0-x234.google.com ([2a00:1450:400c:c05::234])
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <oliveiros.cristina@gmail.com>)
 id 1XrtZ4-0007gn-7K
 for pgsql-sql@postgresql.org; Fri, 21 Nov 2014 19:08:20 +0000
Received: by mail-wi0-f180.google.com with SMTP id n3so219014wiv.7
 for <pgsql-sql@postgresql.org>; Fri, 21 Nov 2014 11:08:17 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=content-type:mime-version:subject:from:in-reply-to:date:cc
 :content-transfer-encoding:message-id:references:to;
 bh=qfAsDi+co8880rEGXEQak9Jtu6egcX8I02SwQktSRmg=;
 b=1IgFe9o8SxWUjH0gdJWXJVKPdKoJe2ibOWzivRLgBqVqgQ4OysbcjrKK18vI5waki7
 xHsdOXrYp2YgqjMw98XvVB87YgYusXJ+zxoh3o+5rf9OQZ2q/l0oFWZpKBlPNSdWi9Ux
 rjcCEGdTI2z07ig1Kt/5WCoaHoaopQZQNnDemullX5iHec5PM6WjrV8xXNMEK1xbHDnE
 iMBUmNRwcd3g6u1soZwZ2wZuKcaaGwluXUGXHHCtvMbQV/zvJE1Jx0OqPgJ/EmvDJPny
 8rrbikbk2QHgY+4YdZ5ZamQq6uYP7R8GSbkiO3aRHB10tlOx5mUv5iYovgfqgtkwJt54
 SWLA==
X-Received: by 10.180.91.137 with SMTP id ce9mr397563wib.60.1416596897378;
 Fri, 21 Nov 2014 11:08:17 -0800 (PST)
Received: from [192.168.100.96] ([89.101.225.242])
 by mx.google.com with ESMTPSA id u9sm1958683wjy.37.2014.11.21.11.08.16
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 21 Nov 2014 11:08:16 -0800 (PST)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (1.0)
Subject: Re: pl/pgsql examples
From: Oliver Christina <oliveiros.cristina@gmail.com>
X-Mailer: iPhone Mail (11B554a)
In-Reply-To: 
 <CAJP7dtAZ6Og40jzr4CtjHheWGOLDRPQ3j-QrB+LYuGbniAe4xQ@mail.gmail.com>
Date: Fri, 21 Nov 2014 19:08:15 +0000
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <14C1EE6D-8967-4E25-9AD2-5B9BB1CF8808@gmail.com>
References: 
 <CAJP7dtAZ6Og40jzr4CtjHheWGOLDRPQ3j-QrB+LYuGbniAe4xQ@mail.gmail.com>
To: Suresh Raja <suresh.rajaabc@gmail.com>
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Not Sure if you need pl/pgsql for that.=20
A insert SELECT query will do if I am understanding what you want to do...

Best,
Oliver=20

Sent from Oliver's iPhone

> On 21 Nov 2014, at 03:48 p.m., Suresh Raja <suresh.rajaabc@gmail.com> wro=
te:
>=20
> Hi :
>=20
> i'm looking for pgsql functions to insert rows from a select query.  I'm =
new pgsql.  So please bear with me.  Can you share some sample code if you =
have. Or if you interested in writing the code, i can out source.
>=20
> Cheers!
> -SR


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql