CODEWITHSUNDEEP
postgresql
Greg Dan
Greg Dan

Reputation: 6318

How to force Postgresql 8.3 string functions to accept non-string data types

There is a note in 8.3 doc which explain why my company application is broken after I upgraded Postgresql from 8.1 to 8.3.

Is there an easy way of altering 8.3 version to behave like 8.1? For example: now with 8.3 when I pass data type to the substr function as first argument then I get an error. 8.1 version silently converted data value to string value.

The application is too big and implicit conversion wound solve the problem.

Upvotes: 1

Views: 412

Answers (1)

Patryk Kordylewski
Patryk Kordylewski

Reputation: 1269

Peter Eisentraut, a PG developer created a SQL script which adds the missing casts. You can get it here.

Upvotes: 3

Related Questions