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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
