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

Question

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.

Patryk Kordylewski · Accepted Answer · 2009-03-17 19:14:36Z

3

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

answered Mar 17, 2009 at 19:14

Patryk Kordylewski

1,2691 gold badge7 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related