On 02/09/2009 15:39, "Andreas Kretschmer" <akretsch...@spamfence.net> wrote:
> Gordon Ross <gr...@ucs.cam.ac.uk> wrote:
>> 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.
Sorry, no joy :-(
grails=> SELECT current_setting('phone.id');
ERROR: unrecognized configuration parameter "phone.id"
grails=> SELECT coalesce(current_setting('phone.id'),'SYSTEM');
ERROR: unrecognized configuration parameter "phone.id"
GTG
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
