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