RE: serial

32,511 9 According to manuals for v4 , sorry but we're not upgrading until next week ;) -----Original Message----- From: Rekaish Bhardwaj [mailto:RekaishB@compans.com] Sent: Thu 12 August 1999 14:12 To: 'Obnoxio The Clown'; robertt@scotlegal.com; informix-list@iiug.org Subject: RE: serial I think its about time we put this to rest. I'm sure the person who originally asked the question is now regretting the posting. Now to change the subject. Anyone know the maximum value of a smallint ...... ?? -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Thursday, August 12, 1999 1:57 PM To: robertt@scotlegal.com; informix-list@iiug.org Subject: Re: serial From: "Robert Taylor" <robertt@scotlegal.com> > > >Anyway*, serial data types will accept values less than 0 (I've just >tried > >this :-), but the autogeneration of serial numbers is always for positive > >Sorry but I don't think this is *always* the case - I think the the >positive >numbers are exhausted then negative numbers will start to be allocated >until >that too is exhausted. AAAAAAAAAAAAAAARGH!!! Can't we just let this die a death? *I'm* exhausted... :-))) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Robert D Taylor wrote: > 32,511 9 According to manuals for v4, sorry but we're not > upgrading until next week ;) Hmm; that sounds more like the maximum number of characters you can use in a single CHAR field in SE. The normal answer is 32767. There again, I could be missing all the irony in the question... > -----Original Message----- > From: Rekaish Bhardwaj [mailto:RekaishB@compans.com] > Sent: Thu 12 August 1999 14:12 > > Now to change the subject. > > Anyone know the maximum value of a smallint ...... ?? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>