2009/1/13 Aleksander Kmetec <aleksander.kmetec@xxxxxxxxx>: > Hi, everyone. > > I'm trying to upgrade a database which is used by several hundred > installations of an app; with each installation possibly running some custom > code and 3rd party extensions. I was hoping that it would be possible to > re-add implicit casts to text for bacwards compatibility with 8.2, since > that would be much easier and smoother than testing all those installations > and/or waiting for bug reports to start pouring in... > > I tried adding casts found here: > http://code.open-bio.org/svnweb/index.cgi/biosql/revision?rev=284 > > Function calls work fine now, but a new problem appeared with operators: > SELECT EXTRACT(DAY FROM NOW()) || 'abc'; > ERROR: operator is not unique: double precision || unknown > > Is there a way to get around this? > You add the cast's but not the operator. The cast is in other way (try to compare with a text '13') for example. > > Regards, > Aleksander > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Emanuel Calvo Franco ArPUG / AOSUG Member Postgresql Support & Admin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
