Re: Filling Missing Primary Key Values - Mailing list pgsql-general

On Thu, 11 Aug 2011, Chris Travers wrote:

> The simplest seems to me to be a sequence and use nextval() to populate
> the null values. The major advantage would be that the sequence could stay
> around in case you need it again. So for example:
>
> create sequence my_varchar_values;

> UPDATE my_table set my_varchar =
> nextval('my_varchar_values')::varchar(12) where my_varchar IS NULL;

Chris,

   I was wondering if this was the best approach since I have new data to add
to the table. Don't need a starting value, eh?

Many thanks,

Rich