On 11 Aug 2001, Dr. Evil wrote:
>
> Is the INT8 datatype well supported in PG? I was just trying to do a
> TO_CHAR(INT8...) and it said that there is no INT8 version of
> TO_CHAR. Also I think I saw on the list here that you can't index on
> INT8. I'm considering using INT8 all over the place in my
> application, because I need ints with up to 14 digits or so. Is this
> a mistake? Should I use some other datatype? And how do I convert
> INT8 to a string?
You answered the to_char thing it looks like...
For indexing, you can do it, you just need to be careful to either
quote or explicitly cast a constant into int8 in order for the
index to get used.