From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.3beta bug or feature? |
Date: | 2008-01-10 17:25:46 |
Message-ID: | B2C55F28-B72A-46A9-A724-5C1611125961@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda pgsql-general |
On Jan 10, 2008, at 10:47 AM, marcelo Cortez wrote:
> folks
>
> the follow queries work in postgres 8.2 but
> in 8.3beta don't work
>
>
> SELECT c.* FROM c WHERE c.numero LIKE '1%';
>
> i think automatic conversion of numeber to text is
> the problem , in 8.3beta don't work
> numero field is integer type
> any ideas?
Read the release notes :) Implicit casts from non-text types to text
have been removed. The easiest solution is to use an explicit cast:
SELECT c.* FROM c WHERE c.numero::text LIKE '1%';
I can definitely see this being an 8.3 faq.
Erik Jones
DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-10 17:29:49 | Re: 8.3beta bug or feature? |
Previous Message | Daniel Ferrer | 2008-01-10 17:23:38 | RV: Consultar Secuencias |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-10 17:26:49 | Re: [GENERAL] 8.3 Beta Incompatible Data Disaster |
Previous Message | Scott Marlowe | 2008-01-10 17:21:51 | Re: 8.2.4 serious slowdown |