> On Mar 20, 2020, at 5:29 PM, Peter J. Holzer <hjp-pgsql@xxxxxx> wrote: > > >> >> >> OP has said small gaps are ok. > > Yes. This wasn't a response to the OP's requirements, but to David's > (rather knee-jerk, IMHO) "don't use sequences" response. Very often the > requirements which would preclude sequences also preclude any other > solution. > > (In the case of the OP's problem, I'd agree that sequences are probably > a bad idea for the reasons he anticipates) > >> To me that says the requirement > > Which requirement? The OP's or the one I posed here? > >> is capricious but we haven’t heard the rationale for the requirement >> yet (or I missed it) > > The OP gave a rationale: He has to fit the counter into an 8-digit > field, and a global counter would overflow that. So he needs per-element > counters. > > hp Isn’t that the implementation of a req along the lines of “we want to number the occurrences of these pairs because ...”? > > -- > _ | Peter J. Holzer | Story must make more sense than reality. > |_|_) | | > | | | hjp@xxxxxx | -- Charles Stross, "Creative writing > __/ | http://www.hjp.at/ | challenge!"
