Re: Understanding DateStyle guc in startup packet

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Re: Understanding DateStyle guc in startup packet
Дата
Msg-id CAB=Je-EmfXoyBRm2LefkxugqNGPta7vf=Ky8ycYpkd02_-WX_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Understanding DateStyle guc in startup packet  (Dave Cramer <davecramer@postgres.rocks>)
Список pgsql-jdbc
>Why would you want to change it?

Applications might have their own view on the way DateStyle connection property should be set.
It could make a difference if the app uses things like select '03-05-2025'::date.

Of course, it would be great if the app code could resist from casting text to dates, however,
I think the driver should stand in the way there by enforcing a very specific DateStyle value.

To me, DateStyle looks like timezone, and client_encoding which we currently enforce, yet we could do better and skip enforcing the values.

Vladimir

В списке pgsql-jdbc по дате отправления: