Re: how plsql work on postgresql

Поиск
Список
Период
Сортировка
От Selina Tech
Тема Re: how plsql work on postgresql
Дата
Msg-id CAOpZfzbGdy1BTgVXZAzgX4XKZjoABwCzqiVbE1EDv+2PjbVWow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how plsql work on postgresql  (Michael Moore <michaeljmoore@gmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Michael Moore
Дата:
Сообщение: Re: how plsql work on postgresql
Следующее
От: Alexander Levsha
Дата:
Сообщение: SQL query syntax question