Re: how plsql work on postgresql

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(at)gmail(dot)com>
wrote:

>
>
> On Wed, Mar 30, 2016 at 8:37 AM, Thomas Kellerer <spam_eater(at)gmx(dot)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(at)postgresql(dot)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
>
>
>