Thread: constants in PL/pgSQL

constants in PL/pgSQL

From
"Marin Dimitrov"
Date:
Hi,

since PL/pgSQL does not have the notion of a package (like in Oracle's
pl/sql) I wander what you do when u need to define some constants that are
common for many PL/pgSQL functions?

right now I have to redefine common error messages/constants/etc again and
again in every function, which induces certain development overhead and will
make maintenance a nightmare

thanx,
   Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "