Postgres Pro
Downloads
Home   >   mailing lists

Re: how plsql work on postgresql - Mailing list pgsql-sql

From Selina Tech
Subject Re: how plsql work on postgresql
Date
Msg-id CAOpZfzbGdy1BTgVXZAzgX4XKZjoABwCzqiVbE1EDv+2PjbVWow@mail.gmail.com
Whole thread Raw
In response to Re: how plsql work on postgresql  (Michael Moore <michaeljmoore@gmail.com>)
List pgsql-sql
Tree view
Hi, All:
     I tried to ask why "LANGUAGE sql" work on postgresql.   Thanks for your reply. Those answer are very helpful.

Sincerely,
Selina

On Wed, Mar 30, 2016 at 10:13 AM, Michael Moore <michaeljmoore@gmail.com> wrote:


On Wed, Mar 30, 2016 at 8:37 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
Michael Moore schrieb am 30.03.2016 um 17:23:
> Like David has said, it is not clear what you are talking about.
>
>   * PL/SQL runs only on an Oracle DB
>   * SQL - there is a Postgres version for Postgres and an Oracle version for Oracle
>   * SPL - This is a language that is added on to Postgres and it is intended to be as much like Oracle PL/SQL as is possible.
>     It allows people to migrate from Oracle to Postgres with minimal changes to code.
>   * PL/PGSQL this is Postgres only. It is kind of like PL/SQL but also very different. I prefer this over SPL because, IMO, it performs better.
>

I have never heard of SPL. Is that a separate module? Where is that available?





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

Thomas, 
It is the language that EnterpriseDB uses. The EnterpriseDB web site appears to be down but here is another link to some information:
http://www.praetoriate.com/t_edb_block_structure.htm
 


pgsql-sql by date:

Previous
From: Michael Moore
Date:
Subject: Re: how plsql work on postgresql
Next
From: Alexander Levsha
Date:
Subject: SQL query syntax question