Monthly Archives: April 2024

PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.

Posted on April 23, 2024 by Deepak Mahto

If you’re fascinated by the internals of PL/pgSQL processing and want to handle it efficiently, especially if you’re migrating procedural logic from another database, be sure to check out the previous posts in the series on PL/pgSQL Conversion Gotchas – … Continue reading →

Rate this:

Posted in postgresql | Tagged , , , , , , | Leave a comment

PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.

Posted on April 12, 2024 by Deepak Mahto

Databases Cursors are one of the key components of development. We have been using them for traversing query results for processing based on business logic or functionality. In Code Conversion, Cursor code always needs to be ported either from PL\SQL … Continue reading →

Rate this:

Posted in Oracle to PG migration, postgresql | Tagged , , , , , , , , , | 1 Comment

PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.

Posted on April 10, 2024 by Deepak Mahto

Whether during conversions or new development, it’s essential to avoid variable names that could create ambiguity within functions or procedures.In the blog, we will walk through how to resolve variables conflicts within functions or procedures. Continue reading →

Rate this:

Posted in Oracle to PG migration, postgresql | Tagged , , , , , , , , , | 4 Comments