I'm now moving into areas of postgres I've not before visited so now and
then I'll ask for directions.
I have a table with 49365 rows. The first column, which I would like to
use as an index, is called 'record' and of type VARCHAR(10). There are 39159
rows in which record IS NULL. I would like to add values to 'record'
starting with 30000. There's no significance to the value of this column
other than as a unique row identifier, and the highest current value is
28569. What is the most efficient way to automate this?
pdxpug by date
|Next:||From: wes||Date: 2011-03-29 19:50:09|
|Subject: Re: Adding Missing Data to a Table|
|Previous:||From: Selena Deckelmann||Date: 2011-03-14 18:16:42|
|Subject: job posting: DBA in Portland|