Re: "Keyed" sequence?

On 04/28/2016 08:30 PM, Israel Brewster wrote:
> This is probably crazy talk, but in Postgresql is there any way to have
> a "keyed" sequence? That is, I have a table with a list of departments.
> While *relatively* static, technically speaking this is a dynamic list -
> someone certainly could decide to add a department, or combine two
> departments into one new one, whatever. In any case, I would ideally
> like to have a sequence per department, but since the list is dynamic
> it's not as simple as creating 33 independent sequences and then having
> a lookup table somewhere, although I guess I could implement something
> of the sort with triggers.

What would be the point of this?  Why not just one sequence for all
departments?
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support