| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Dr(dot) Evil" <drevil(at)sidereal(dot)kz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: INT8 in Postgres |
| Date: | 2001-08-11 17:08:00 |
| Message-ID: | Pine.BSF.4.21.0108111005380.57092-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Harr | 2001-08-11 21:26:53 | Re: Postmaster Question ? |
| Previous Message | Andrew Gould | 2001-08-11 17:06:51 | Re: Query help... |