On 08.03.2017 03:37, Robert Haas wrote:
The commit message for 64353640e87b54250f1b8a1d2a708d270dff4bfd has
some interesting perspective on this.


"""
Also, mark to_date() and to_char(interval) as stable; although these appear
not to depend on any GUC variables as of CVS HEAD, that seems a property
unlikely to survive future improvements.  It seems best to mark all the
formatting functions stable and be done with it.
"""

My take away from this commit is the following:

Historically, the immutability of "to_date(text, text)" was an emergent feature. Proven to be possibly mutable, the parsing feature had a higher priority, so the immutability needed to be removed.

The proposed variant on the other hand should be immutable first before everything else. Thus, future improvements cannot violate that. This might restrict the possible parsing functionality but that shouldn't be a problem in practice.

Regards,
Sven


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to