From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.3beta bug or feature? |
Date: | 2008-01-10 20:02:14 |
Message-ID: | 1199995334.10057.428.camel@dogma.ljc.laika.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda pgsql-general |
On Thu, 2008-01-10 at 16:19 -0300, marcelo Cortez wrote:
> > The cast already exist; I think you could change its
> > context (from
> > "explicit" to "assignment" IIRC). This is, of
> > course, not recommended.
>
>
> I've created cast with assignment from in4 to text
>
> but
> select 23 LIKE '2%' fail.
> ERROR: operator does not exist: integer ~~ unknown
> LINE 1: select 23 LIKE '2%'
> ^
> HINT: No operator matches the given name and argument
> type(s). You might need to add explicit type casts.
First of all, I think Alvaro meant "change to implicit", I don't think
"assignment" will help.
Second, assuming that works for that specific case (which it may or may
not, I haven't tried it), it's still not a good solution for you.
Implicit type coercion causes all kinds of subtle problems that are hard
to see, which is why the change was made in 8.3.
And if I understand correctly, just changing a few casts to "implicit"
will not result in behavior the same as 8.2, so it's likely to break
other parts of the application.
I don't think there's any way around fixing the application. You can
still use 8.2 with tsearch2 (which still work great) until the mapper is
fixed.
What is the name of the third-party product?
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Raul Andres Duque | 2008-01-10 20:55:38 | Re: Problemas al actualizar una BD |
Previous Message | Sistemas CTD SRL | 2008-01-10 19:33:03 | RV: RV: Consultar Secuencias |
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo | 2008-01-10 20:18:05 | Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4? |
Previous Message | Isak Hansen | 2008-01-10 20:00:47 | Re: 8.2.4 serious slowdown |