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? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster