Re: Improve documentation for current_setting function

Eugen Konkov <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.documentation
Message-ID <[email protected]>
Hello Bruce,

> How do you like the attached patch, which clarifies this?

>>in which case a missing parameter returns
>>!     NULL.

not  always. It can be NULL or empty string. It depends if the current
session is new or after finished transaction which makes 'local' changes
to setting

Take into account these steps: https://www.postgresql.org/message-id/15646-0d3caee9f6266f60%40postgresql.org

From  my  user point of view. if the boot value before transaction was
NULL then after transaction it MUST stay NULL and not empty string.

This  will  be  consistent with that if I open new parallel session it
will return NULL.

Also I see NULL value (if setting was not defined) is useful.


Also this:
set_config( 'my.name', NULL )
must  set 'my.name' to NULL or must issue warning about NULL is turned
into empty string.

Personally  I  dislike  that  NULL  is converted to empty string. This
looks ugly. =(

-- 
Best regards,
Eugen Konkov
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.