That is where we started -- for next number

}>> Subject: Re: Cheryl - 'nest number' }>> Date: 25 Aug 1993 09:46:27 +0200 }>> Reply-To: Knut Espen Vonheim <knutv@hadrian.boers.no> }>> Organization: Oslo B|rs Informasjon }>> }>> }>> Cheryl! }>> }>> If you want to use smallint instead of serial (save diskspace etc) }>> you could try: }>> }>> $select max(nsnkey)+1 into $newkey from nsn }>> }>> }>> That should give you the next number and i should be unique. }>> }>> That is where we started. Someone posted a message about this taking too long. My process for getting the next number takes less than a second. The sequential search takes too long, I've had problems with serial fields, and want to stay smallint, if possible. Sometimes, I'm using this number to build a larger reference record. cheryl