Rhys,You could create a sequence, then make the "seq" attribute to your table have a default value of:
seq integer default nextval('your_sequence')Then every time an insert is done into your table, the "seq" will increment. You alternatively could make your "insert" statement have for that position, the nextval('your_sequence')
Does that help? Rhys Stewart wrote:
Hi all, looking for a method to number a table sequentially, but the sequence only increments if the value in a certain column is different. as in seq | parish ------------------------ 1 | Kingston 1 | Kingston 1 | Kingston 1 | Kingston 2 | Lucea 3 | Morant Bay 3 | Morant Bay 3 | Morant Bay 4 | Port Antonio 5 | Savannah-La-Mar 5 | Savannah-La-Mar 5 | Savannah-La-Mar so i guess i would order by a certain column and then the 'magic sequence' would be a column that only increments when the column changes. Rhys ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
-- Email: [EMAIL PROTECTED] WebSite: http://www.linuxlouis.net "Open the pod bay doors HAL!" -2001: A Space Odyssey "Good morning starshine, the Earth says hello." -Willy Wonka ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
