Subject: Re: how plsql work on postgresql
To: Selina Tech <swucareer99@gmail.com>, pgsql-sql@postgresql.org
References: 
 <CAOpZfzYNoYpqDUxS0Q8AkJxuE+Ng9KJ+mpAYxekj3SdDNmT3rA@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <56FB0CBA.8010804@aklaver.com>
Date: Tue, 29 Mar 2016 16:16:10 -0700
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.7.1
MIME-Version: 1.0
In-Reply-To: 
 <CAOpZfzYNoYpqDUxS0Q8AkJxuE+Ng9KJ+mpAYxekj3SdDNmT3rA@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 03/29/2016 03:57 PM, Selina Tech wrote:
> Hi, All
>
>           I just start to learn plsql and plpgsql. There are a lot of
> comparison of pl/sql and pl/pgsql available online. I am wondering why
> plsql work well on Postgresql and how it work? Is the code converted to
> plpgsql code?
>             If use postgresql database server, which one is better
> between plsql and pl/pgsql?

I find myself using pl/pgsql more then plsql(assuming you mean 
this(http://www.postgresql.org/docs/9.5/interactive/xfunc-sql.html)) 
just because pl/pgsql offers more ways to manipulate data. FYI, there 
are languages available e.g. pl/pythonu, pl/perl, pl/tcl. pl/java, etc.

Some resources:

http://www.postgresql.org/docs/9.5/interactive/plpgsql-porting.html

http://ora2pg.darold.net/documentation.html#plsql_to_plpsql_convertion
>
>
> Your feedback is highly appreciated.
>
> Sincerely,
> Selina


-- 
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