On Mon, Dec 10, 2001 at 04:30:45PM +0100, Mourad EL HADJ MIMOUNE wrote:
>
> I use sequence to generate an ID for each row by using a same sequence for
> all tables (it's a same as an OID). I want know the limit of number
> genereted by a sequence. Did sequence use short or long integer?
From the `HISTORY' file of PostgreSQL CVS:
Sequences now use int8 internally (Tom)
From file `backend/commands/sequence.c':
Datum
nextval(PG_FUNCTION_ARGS)
{
..
PG_RETURN_INT64(result);
}
--
Holger Krug
hkrug@rationalizer.com