Re: TO_DATE function between PostgreSQL 8.2 and 9.4

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(dot)klaver(at)aklaver(dot)com