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