Re: Best approach for a "gap-less" sequence - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Best approach for a "gap-less" sequence
Date
Msg-id 87zme7uvcn.fsf@gmail.com
Whole thread Raw
In response to Re: Best approach for a "gap-less" sequence  (Harald Fuchs <hf0731x@protecting.net>)
List pgsql-general
Harald Fuchs <hf0731x@protecting.net> writes:

> Why putting gapless numbers into the database at all?  Just calculate them at
> query time.

And how would you retrieve the record that corresponds to invoice number
#16355, for example?  Recalculating few records is fine, but millions of them
everytime you need to recover some of those is something that doesn't look
efficient to me...

--
Jorge Godoy      <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Best approach for a "gap-less" sequence
Next
From: "Jaime Casanova"
Date:
Subject: Re: problem with a dropped database