Re: Oracle PL/SQL to pg/PSQL conversion documentation.

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Oracle PL/SQL to pg/PSQL conversion documentation.
Date: 2015-12-02 21:02:52
Message-ID: CACpWLjOd-cimUXzc2QW4H8fPausxrvoCm87cGbohYdT_ABatZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks Adrian. I've seen that one before, and it is indeed very useful.
Unfortunately it does not address many of the features that need
converting. For example, how to deal with a BULK COLLECT, TABLE functions,
context variables. Maybe I am hoping for too much. Again, thanks, Mike

On Wed, Dec 2, 2015 at 12:47 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 12/02/2015 12:44 PM, Michael Moore wrote:
>
>> Ideally I would like to see some template/example documentation of
>> common feature conversion solutions. For example, "If you have a pl/sql
>> TABLE function, you can do the same thing in postgres this way ..." I
>> can generally Google specific problems and after enough time weeding out
>> the garbage, I can usually find what I want, but maybe somebody has it
>> all in one nice neat document and I just don't know about it.
>> Any links to such a resource would be greatly appreciated as well as any
>> other links which you think I might find useful.
>>
>
> http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html
>
> Thanks,Mike
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sribeiro 2015-12-02 21:06:37 Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map
Previous Message Adrian Klaver 2015-12-02 20:47:40 Re: Oracle PL/SQL to pg/PSQL conversion documentation.