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

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.klaver@aklaver.com

<div dir="ltr">Thanks Adrian. I've seen that one before, and it is indeed very useful. Unfortunately it does not
addressmany of the features that need converting. For example, how to deal with a BULK COLLECT,  TABLE functions,
contextvariables. Maybe I am hoping for too much. Again, thanks, Mike</div><div class="gmail_extra"><br /><div
class="gmail_quote">OnWed, Dec 2, 2015 at 12:47 PM, Adrian Klaver <span dir="ltr"><<a
href="mailto:adrian.klaver@aklaver.com"target="_blank">adrian.klaver@aklaver.com</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 12/02/2015
12:44PM, Michael Moore wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">Ideally I would like to see some template/example documentation of<br /> common feature
conversionsolutions. For example, "If you have a pl/sql<br /> TABLE function, you can do the same thing in postgres
thisway ..." I<br /> can generally Google specific problems and after enough time weeding out<br /> the garbage, I can
usuallyfind what I want, but maybe somebody has it<br /> all in one nice neat document and I just don't know about
it.<br/> Any links to such a resource would be greatly appreciated as well as any<br /> other links which you think I
mightfind useful.<br /></blockquote><br /></span><a
href="http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html"rel="noreferrer"
target="_blank">http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html</a><br/><br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Thanks,Mike<br /><br /><span
class="HOEnZb"><fontcolor="#888888"> </font></span></blockquote><span class="HOEnZb"><font color="#888888"><br /><br />
--<br /> Adrian Klaver<br /><a href="mailto:adrian.klaver@aklaver.com" target="_blank">adrian.klaver@aklaver.com</a><br
/></font></span></blockquote></div><br/></div>