On Thu, 15 Aug 2002, Stephan Szabo wrote:
>
> 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).
(Slow today) The same is true for int2 (which is despite my braindamage
today large enough to hold 12345) except that you cast to int2.