From: | Alvaro Herrera <alvherre(at)commandprompt(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:12:57 |
Message-ID: | 20080110171257.GL6465@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda pgsql-general |
marcelo Cortez escribió:
> 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
This is regarded as a feature by some, bug by others. It's an
intentional change either way. You can work around it:
SELECT c.* FROM c WHERE c.numero::text LIKE '1%';
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Sistemas CTD SRL | 2008-01-10 17:18:34 | RV: Consultar Secuencias |
Previous Message | Pavel Stehule | 2008-01-10 17:08:49 | Re: 8.3beta bug or feature? |
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2008-01-10 17:19:25 | Re: [GENERAL] 8.3 Beta Incompatible Data Disaster |
Previous Message | Pavel Stehule | 2008-01-10 17:08:49 | Re: 8.3beta bug or feature? |