Re: Legacy app not working with newer PG, is there a quick fix?

Am 08.02.19 um 16:27 schrieb Lars Gustafsson:
> I have a legacy client java application that I try to run against a new Postgres server.
> All data migrates as expected. Everything seems to work ok, except for one thing.
>
> ERROR: function to_date(timestamp without time zone, unknown) does not exist at character 9
> HINT: No function matches the given name and argument types. You might need to add explicit type casts.
>
> The application was written with and works with PG 8.2.3
>
> I understand that from PG 8.3 explicit typecasting is necessary, like:
> to_date(cast(createddate as TEXT),'YYYY-MM-DD’)
>
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com