Mostly I'm pointing out the fact that one can never take the null value to be the actual value of a setting. In terms of current_setting this then establishes the fact that the null value it may return is an error-handling alternative only and not something to be relied upon as being an actual value of the setting.
- Returns the current value of the+ Returns the current non-null value of the setting <parameter>setting_name</parameter>. If there is no such setting, <function>current_setting</function> throws an error unless <parameter>missing_ok</parameter> is supplied and
Hi,
current_setting() could return NULL when missing_ok is passed, so is it right to say: Returns the current non-null value of the setting <parameter>setting_name</parameter>? As the doc is for function of current_setting(), and it could return NULL actually.
Yes, and when it does it is doing so in lieu of an error, and thus it is not returning the value of the setting. It does not mean the value taken on by the named parameter is NULL, which is not possible. i.e., SHOW will never produce NULL.
