Hello, it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html E.1.2.1. General Regards Pavel Stehule On 10/01/2008, marcelo Cortez <[EMAIL PROTECTED]> wrote: > 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 > any ideas? > > best regards > mdc > > ps:"PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled > by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)" > > > ERROR: operator does not exist: integer ~~ unknown > LINE 2: c.numero LIKE '1%') > > ^ > HINT: No operator matches the given name and argument > type(s). You might need to add explicit type casts. > > ********** Error ********** > > ERROR: operator does not exist: integer ~~ unknown > Estado SQL:42883 > Sugerencias:No operator matches the given name and > argument type(s). You might need to add explicit type > casts. > Caracter: 141 > > > > > > Tarjeta de crédito Yahoo! de Banco Supervielle. > Solicitá tu nueva Tarjeta de crédito. De tu PC directo a tu casa. > www.tuprimeratarjeta.com.ar > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
