From: | Selina Tech <swucareer99(at)gmail(dot)com> |
---|---|
To: | postgres list <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: how plsql work on postgresql |
Date: | 2016-03-30 17:56:52 |
Message-ID: | CAOpZfzbGdy1BTgVXZAzgX4XKZjoABwCzqiVbE1EDv+2PjbVWow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Levsha | 2016-04-04 07:19:35 | SQL query syntax question |
Previous Message | Michael Moore | 2016-03-30 17:13:43 | Re: how plsql work on postgresql |