Re: TO_DATE function between PostgreSQL 8.2 and 9.4

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: TO_DATE function between PostgreSQL 8.2 and 9.4
Дата
Msg-id b25f7f07-4b7e-ccdb-abe1-fc5ccfede1fa@aklaver.com
обсуждение исходный текст
Ответ на Re: TO_DATE function between PostgreSQL 8.2 and 9.4  (John W Higgins <wishdev@gmail.com>)
Список pgsql-general
On 5/17/22 9:23 AM, John W Higgins wrote:
> Good Morning,
> 

> Just create the missing function
> 
> create function to_date(timestamp with time zone, text) RETURNS text AS
>     'SELECT to_date($1::text, $2)::text'
>     LANGUAGE SQL
>     IMMUTABLE;


That is just kicking the can down the road. What the OP is running into 
is the tip of the iceberg of the changes not only in 8.3 but the other 6 
major versions involved. The time spent trying to create a compatibility 
layer for this jump and subsequent jumps would be better spent actually 
making the code current.

> John


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: TO_DATE function between PostgreSQL 8.2 and 9.4
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Restricting user to see schema structure