chester c young wrote:
> anybody have a good way to impliment constants in the database?
>
> using an immutable pgpgsql function, constant_name() - works, but not
> necessarily very efficient.
A function declared IMMUTABLE should be efficient enough; it'll usually be evaluated once per query at most. The real answer is, as usual, "it depends." What're you trying to accomplish with a constant?