Mirek Budzanowski <mirekb(at)tcs(dot)uni(dot)wroc(dot)pl> writes:
> Anyone have any idea how to define a index ont int8 field?
Postgres 6.4 doesn't have support for indexes on int8.
In theory you could add it for yourself (there is some documentation
about index operators in the Developer's Guide) but it's not a simple
job. You would probably be better off to wait for 6.5, which does
have int8 index support...
regards, tom lane