Michael Ludwig schrieb am 10.05.2010 um 21:54:25 (+0200):

> To sum it up, in addition to the non-global solution presented by
> emb_blaster above, the following four global solutions were proposed:
>
> (1) generators which you never increment
> (2) stored procedures returning a constant
> (3) UDFs returning a constant (all by "unordained")
> (4) regular tables for lookup (by Alan McDonald)
>
> Still, I think constants as database objects would be very useful

In the absence of which, of course, we can fall back on a primitive yet
efficient solution that I'd prefer to all the aforementioned ones:

(5) Preprocess your DDL script using a macro or template processor,
such as m4 or Template::Toolkit or whatever you like best to
replace YourNamedConstants with the actual values.

--
Michael Ludwig