Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to create implicit casts to text in PG 8.3 - Mailing list pgsql-general

From Aleksander Kmetec
Subject Re: Trying to create implicit casts to text in PG 8.3
Date
Msg-id 496CC4C8.3090302@intera.si
Whole thread Raw
In response to Re: Trying to create implicit casts to text in PG 8.3  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Responses Re: Trying to create implicit casts to text in PG 8.3
List pgsql-general
Tree view 
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 else besides creating implicit casts and adding missing operators? And will

this introduce any side effects which are not compatible with 8.2 and might break my queries in unpredictable ways?

Regards,
Aleksander

pgsql-general by date:

Previous
From: Emanuel Calvo Franco
Date:
Subject: Re: Cast for text->Integer missing in 8.3.5
Next
From: Aleksander Kmetec
Date:
Subject: Re: Cast for text->Integer missing in 8.3.5