Re: 8.3beta bug or feature?

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

In response to

Browse pgsql-es-ayuda by date

  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?

Browse pgsql-general by date

  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?