Re: how plsql work on postgresql

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(dot)klaver(at)aklaver(dot)com