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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
