Gordon Ross <gr306@xxxxxxxxxxxxx> wrote: > (I'm using Postgres 8.3) > > I have a trigger that references a custom variable. Most of the time this > custom variable is set, and I have no problems. > > However, in certain corner cases the custom variable is not set and the > trigger fails. > > Is there a way to either test if the custom variable is set, or to specify a > global default for the custom variable ? I think, you can use COALESCE(your_variable, default_value) to solve that problem. Try it, it is untested. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
