On 02/09/2009 15:39, "Andreas Kretschmer" <akretschmer(at)spamfence(dot)net> wrote:
> Gordon Ross <gr306(at)ucs(dot)cam(dot)ac(dot)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