3 ms·
From the release notes: >Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional
by mberger 9y ago
From the release notes:
>Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional behavior
TIL PL/pgSQL exists so I googled it. In the page for porting from Oracle PL/SQL:
>Instead of packages, use schemas to organize your functions into groups.
Does anyone know if there are plans to introduce packages in Postgres? Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas?
*edit:formatting
- pritambaral 9y ago> Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas? In Pg, schemas don't talk to schemas. When a function is run, it runs with the privilege level of either the user that called it, or the user that defined it.