On Fri, Jun 5, 2020 at 11:16:59AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/functions-formatting.html > Description: > > For the formatting functions, which convert between a string and a type like > date, timestamp or number, there should be a description about the behaviour > of i.e. to_date(input, mask) in case of invalid, not convertable input. > > I expected a return value of NULL and got a execution error.
Well, the value isn't "unknown", it is invalid, so an error seems appropriate. I don't remember anyone complaining the expected a NULL return. -- Bruce Momjian <br...@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
