Postgres Pro
Downloads
Home   >   mailing lists

Re: Documentation 9.8. Data Type Formatting Functions: missingbehaviour on invalid input at to_date() - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: Documentation 9.8. Data Type Formatting Functions: missingbehaviour on invalid input at to_date()
Date
Msg-id 20200612212819.GA6813@momjian.us
Whole thread Raw
In response to Documentation 9.8. Data Type Formatting Functions: missing behaviour on invalid input at to_date()  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: Documentation 9.8. Data Type Formatting Functions: missingbehaviour on invalid input at to_date()
List pgsql-docs
Tree view 
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  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

pgsql-docs by date:

Previous
From: "Fontana Daniel C \(Desartec S.R.L.\)"
Date:
Subject: Replication Binary in PostgreSQL 12
Next
From: Bruce Momjian
Date:
Subject: Re: create database with template doesn't copy ACL