On Sep 10, 2024, at 16:10, Peter Eisentraut <pe...@eisentraut.org> wrote:
> These JSON path functions are specified by the SQL standard, so they > shouldn't depend on PostgreSQL-specific settings. At least in new > functionality we should avoid that, no? Does that also apply to `datetime(template)`, where it uses the `to_timestamp()` templates? From the docs[1]: > The datetime() and datetime(template) methods use the same parsing rules as > the to_timestamp SQL function does (see Section 9.8[2]), with three > exceptions. First, these methods don't allow unmatched template patterns. > Second, only the following separators are allowed in the template string: > minus sign, period, solidus (slash), comma, apostrophe, semicolon, colon and > space. Third, separators in the template string must exactly match the input > string. Does the standard specify a formatting language? Best, David [1]: https://www.postgresql.org/docs/devel/functions-json.html [2]: https://www.postgresql.org/docs/devel/functions-formatting.html
