|Subject||Re: [ib-support] Generating a unique ID|
At 19.57 09/11/2001 +0100, you wrote:
>Marco,I don't understand what do u mean.
> > > > P.S. I usually use as primary key a NUMERIC(18,4) column that is stored
> > > > into a 64Bit
> > > > INTEGER and fill it with a generator.
> > >
> > >did you mean (18, 0)?
> > 18,0 are stored as INT64.
> > It's almost the same for a primary key.
>Can you tell the difference between a 64bit integer and an INT64?
>Anyway, I seem to recall that a NUMERIC(18, 4) does not fit in 64 bitsIt stores in INT64.
>without oveflowing, whereas a NUMERIC(18, 0) does.