I don't know the most efficient way to automate such a task, I only know my
way, which would be to make it up as I go along.
However, I must ask, out of curiosity: why would you want to index a column
whose contents are irrelevant?
On Tue, Mar 29, 2011 at 11:31 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)com>wrote:
> 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
> 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?
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pdxpug by date
|Next:||From: Rich Shepard||Date: 2011-03-29 20:23:25|
|Subject: Re: Adding Missing Data to a Table|
|Previous:||From: Rich Shepard||Date: 2011-03-29 18:31:12|
|Subject: Adding Missing Data to a Table|