Re: [GENERAL] Trying to create implicit casts to text in PG 8.3

2009-01-13 Thread Emanuel Calvo Franco
2009/1/13 Aleksander Kmetec aleksander.kme...@intera.si: 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: [GENERAL] Trying to create implicit casts to text in PG 8.3

2009-01-13 Thread Aleksander Kmetec
Emanuel Calvo Franco wrote: You add the cast's but not the operator. The cast is in other way (try to compare with a text '13') for example. Thanks. I added both ||(double precision, text) and ||(text, double precision) operators and it works now. But I'm wondering: do I need to do anything

Re: [GENERAL] Trying to create implicit casts to text in PG 8.3

2009-01-13 Thread Sam Mason
On Tue, Jan 13, 2009 at 05:43:52PM +0100, Aleksander Kmetec wrote: I added both ||(double precision, text) and ||(text, double precision) operators and it works now. But I'm wondering: do I need to do anything else besides creating implicit casts and adding missing operators? And will this

Re: [GENERAL] Trying to create implicit casts to text in PG 8.3

2009-01-13 Thread Joshua D. Drake
On Tue, 2009-01-13 at 16:58 +, Sam Mason wrote: In the end, any type system is just a tool. It's main job is to find bugs in code by spotting a common class of error The purpose of the database as a whole is to preserve the integrity of your data. The type system is a key component of

Re: [GENERAL] Trying to create implicit casts to text in PG 8.3

2009-01-13 Thread Sam Mason
On Tue, Jan 13, 2009 at 09:14:15AM -0800, Joshua D. Drake wrote: On Tue, 2009-01-13 at 16:58 +, Sam Mason wrote: In the end, any type system is just a tool. It's main job is to find bugs in code by spotting a common class of error The purpose of the database as a whole is to preserve

[GENERAL] Trying to create implicit casts to text in PG 8.3

2009-01-12 Thread Aleksander Kmetec
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