Re: 8.3beta bug or feature?

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