Oracle to PostgreSQL — Cursors and ltrees
This time we talk about using ltree as an alternative to PostgreSQL cursors.
This time we talk about using ltree as an alternative to PostgreSQL cursors.
PostgreSQL has quite a number of better algorithmic alternatives to cursors. We’ll start by examining the advantages of Common Table Expressions.
Binary Objects in PostgreSQL definitely have caveats, and don’t behave the way you might expect coming from an Oracle background. This article demystifies the Blob, gives some practical advice for dealing with them, and improves your philosophy.
PostgreSQL has quite a few compelling advantages, some of which are not found in any other database management system. This article will outline the ones that are most interesting to the Oracle developer seeking to do a migration or investigate alternatives for new development. To prevent this article from becoming another list of PostgreSQL features, it […]