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: louis.gonzales@linuxlouis.net
WebSite: http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka