constants in PL/pgSQL

From: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: constants in PL/pgSQL
Date: 2002-03-22 10:39:23
Message-ID: 004e01c1d18d$d5315ae0$9b0e32d4@sirma.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


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. "

Browse pgsql-interfaces by date

  From Date Subject
Next Message S. Bulterman 2002-03-23 19:18:15 Re: Problem with pgaccess
Previous Message Michael Meskes 2002-03-21 17:56:15 Re: ARRAY