log statement doesn't

[Simon Hobson]

"Hughes, Doug" <Douglas.Hughes at DEShawResearch.com> wrote:

> First and foremost, I had to use 'option option125' or it would fail silently.

Ah yes, that gotcha.

If I understand the nuances correctly ...

It would fail silently because "substr(foo...)" is a valid expression - but since foo will itself be unset (null value), the result is simply a null value.
In this case, it uses the server variable called foo - which may be a server set option IIRC.

In the version you need to use, "substr(option foo...)", the "option" keyword means to use the value of the option foo rather than a server variable.