Re: TO_DATE function between PostgreSQL 8.2 and 9.4 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: TO_DATE function between PostgreSQL 8.2 and 9.4
Date
Msg-id b25f7f07-4b7e-ccdb-abe1-fc5ccfede1fa@aklaver.com
Whole thread Raw
In response to Re: TO_DATE function between PostgreSQL 8.2 and 9.4  (John W Higgins <wishdev@gmail.com>)
List 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 by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: TO_DATE function between PostgreSQL 8.2 and 9.4
Next
From: Bryn Llewellyn
Date:
Subject: Re: Restricting user to see schema structure