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
[EMAIL PROTECTED] ("Rhys Stewart") writes:
> 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 | K
On Oct 17, 2006, at 23:18 , 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
[snip]
Normalization could solve your problem and also improve your schema:
-- The parish table
cr
