On Thu, 15 Aug 2002, Diogo Biazus wrote:
> Hi everybody.
> Im trying to execute a simple UPDATE query on a table with 450000 rows
> using an index in the where clause.
>
> Example:
> UPDATE table SET field = null WHERE field = 12345
> ( NOTICE: Field has an index )
If field is int8, you'll need to either quote the number or
cast it to int8 (either ::int8 or cast(12345 as int8) should work).