Re: serial column

[Gevik Babakhani <pgdev(at)xs4all(dot)nl>]

On Sun, 2006-09-24 at 15:29 -0700, Bob Pawley wrote:
> "A possible solution for this would be to regenerate the entire column's
> values every time a record gets deleted starting form 1. but then again
> this would be very slow if you have a very large table"
> 
> I don't anticipate the table to be more than a few hundred rows - certainly 
> fewer than 1,000.
> 
> Could you point to some documentation for regenerating a column's values 
> other than manual??
> 
> Bob
> 
 I am afraid there is no built-in way to do that.
perhaps you could create a function that:
step1: creates a sequence (with random name)....
step2: update table set field=netval('random_seq_name');
step3: drop sequence...

-- 
Regards,
Gevik Babakhani