Обсуждение: sequence max values

I have created a sequence.  It appears, although I cant find this
documented, that the max value we can have in our sequence is around
2,140,000,001

I say 'around' because it would take me a while to figure out the exact max.
It works at 2,140,000,001  but fails at  2,150,000,001

Can anyone tell me (or show me where to look it up in the documentation)
what the range of values is for a sequence?

Thanks, Charlie Crissman

Charlie Crissman
Sr. Oracle DBA
Oracle Certified Professional DBA
No Boundaries Network, Inc.
904-245-6839
Pager 904-840-3684
mailto:CCrissman@nbibx.com <mailto:CCrissman@nbibx.com>
Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their
shoes.

Charlie Crissman writes:

> I say 'around' because it would take me a while to figure out the exact max.
> It works at 2,140,000,001  but fails at  2,150,000,001
>
> Can anyone tell me (or show me where to look it up in the documentation)
> what the range of values is for a sequence?

http://www.postgresql.org/users-lounge/docs/7.0/user/datatype.htm#AEN942

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/