Stephan Szabo wrote:
>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.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
>
Yes, the field is int8 and now its working fine (with the quotes),
thanks for the help.
Diogo Biazus