Re: Adding Missing Data to a Table

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?

-wes

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
> 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?
>
> Rich
>
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug
>