Re: Allow to_date() and to_timestamp() to accept localized names

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Allow to_date() and to_timestamp() to accept localized names
Дата
Msg-id
20200124161814.GA8989@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Arthur Zakirov <zaartur@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Arthur Zakirov <zaartur@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Mark Dilger <mark.dilger@enterprisedb.com>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Mark Dilger <mark.dilger@enterprisedb.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Mark Dilger <mark.dilger@enterprisedb.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names James Coleman <jtc331@gmail.com>
Re: Allow to_date() and to_timestamp() to accept localized names Mark Dilger <mark.dilger@enterprisedb.com>
Re: Allow to_date() and to_timestamp() to accept localized names Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow to_date() and to_timestamp() to accept localized names Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
On 2020-Jan-24, Peter Eisentraut wrote:

> When you interact with glibc locale functions, you essentially have to
> assume that everything is in NFC.  When using ICU locale functions (which we
> don't here, but just for the sake of argument), then I would expect that ICU
> does appropriate normalization itself when I call
> icu_what_month_is_this(string) returns int.  So I think it is appropriate to
> not deal with normalization in this patch.

But that's a different POV.  The input to this function could come from
arbitrary user input from any application whatsoever.  So the only
reason we can get away with that is because the example regression case
Juan José added (which uses non-normals) does not conform to the
standard.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления
От: David Steele
Дата:
От: Tom Lane
Дата:
FAQ