Message-ID: <546F6161.6080606@aklaver.com>
Date: Fri, 21 Nov 2014 07:59:29 -0800
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:31.0) Gecko/20100101 Thunderbird/31.2.0
MIME-Version: 1.0
To: Suresh Raja <suresh.rajaabc@gmail.com>, pgsql-sql@postgresql.org
Subject: Re: pl/pgsql examples
References: 
 <CAJP7dtAZ6Og40jzr4CtjHheWGOLDRPQ3j-QrB+LYuGbniAe4xQ@mail.gmail.com>
In-Reply-To: 
 <CAJP7dtAZ6Og40jzr4CtjHheWGOLDRPQ3j-QrB+LYuGbniAe4xQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 11/21/2014 07:48 AM, Suresh Raja wrote:
> Hi :
>
> 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.

Could you provide some pseudo code outlining what is want to accomplish?

Say something like:

CREATE FUNCTION some_fnc()
SELECT fld_1, fld_2, fld_3 FROM some_table WHERE id = <some_parameter>
INSERT INTO another_table(fld1, fld2, fld3) VALUES(fld_1, fld_2, fld_3)

Obviously this a simple contrived example. The more detail you can 
provide, the better.

>
> Cheers!
> -SR


-- 
Adrian Klaver
adrian.klaver@aklaver.com


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