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 pre

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 tha

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 w

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 anyth

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 : > 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 te

[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 8.2