4 ms·
Does anybody use PG/PLSQL? I wonder how it compares in practice with Oracle PLSQL.
by CSDude 11y ago
Does anybody use PG/PLSQL? I wonder how it compares in practice with Oracle PLSQL.
- mauricemir 11y agoIts quiet close I recall being impressed that i could reuse some Oracle Pl/SQL on Postgress
- jmulho 11y agoIf you know PL/SQL, all you need is an example of the boilerplate that goes at the top and bottom of a PL/pgSQL procedure and you are good to go.
- cgh 11y agoAs others have mentioned, they are similar but there are some gotchas. An example is hierarchical data: pgsql lacks start with/connect by. This means you have to write recursive queries using Common Table Expressions (with...as). Not a dealbreaker but it does mean some extra work.