FX modifier
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/functions-formatting.html
Description:
The FX modifier is defined only as "fixed format global option"--what does
this mean?
The usage notes do not mention FX for TO_CHAR. Does it work with TO_CHAR?
2018-06-14 17:16 GMT-03:00 PG Doc comments form <noreply@postgresql.org>:
The FX modifier is defined only as "fixed format global option"--what does
this mean?
The usage notes do not mention FX for TO_CHAR. Does it work with TO_CHAR?
This is not a bug. The documentation is clear.
"to_timestamp and to_date skip multiple blank spaces in the input
string unless the FX option is used. For example, to_timestamp('2000
JUN', 'YYYY MON') works, but to_timestamp('2000 JUN', 'FXYYYY
MON') returns an error because to_timestamp expects one space only. FX
must be specified as the first item in the template."
FX only applies to to_timestamp and to_date.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento