On 02/09/2009 15:39, "Andreas Kretschmer" <akretschmer@xxxxxxxxxxxxx> wrote:
> Gordon Ross <gr306@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
