Skip site navigation (1) Skip section navigation (2)

Re: Adding Missing Data to a Table

From: wes <pdxpug(at)the-wes(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Adding Missing Data to a Table
Date: 2011-03-29 19:50:09
Message-ID: AANLkTimEq9wa4rSJRcoPs9fyo_dtkGDUkddkBG4ab-Aj@mail.gmail.com (view raw or flat)
Thread:
Lists: pdxpug
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
>

In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2011-03-29 20:23:25
Subject: Re: Adding Missing Data to a Table
Previous:From: Rich ShepardDate: 2011-03-29 18:31:12
Subject: Adding Missing Data to a Table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group