A simple Sql question

From: Abiy Alemu <abiy_at_biotec.jouy.inra.fr>
Date: Wed, 1 Jul 1998 08:59:30 +0200
Message-ID: <Pine.SOL.3.91.980701085900.5372A-100000@biotec>

creating a unique index on a column of a table containing very large number of data rows. What I would like to do is a follows :

Example : I have the following data
  staion_number station_reference power

    0001                 STATION1		   150
    0002                 STATION2            250
    0003                 STATION2            253
    0004	             STATION2            350
    0005                 STATION3            400

And I would like to, by an update statement have the following
  staion_number      station_reference      power

    0001                 STATION1		   150
    0002                 STATION2            250
    0003                 STATION2-1          253
    0004	             STATION2-2          350
    0005                 STATION3-3          400

or renaming in some other simple way.

Is it possible to do it. If it is, how ?

|-----------------------------------------------------------------------------|


| If the only tool you have is a        | Abiy Alemu abiy_at_biotec.jouy.inra.fr |


| hammer, everything in the world       | 9, avenue calmels                   |


| seems like a nail.____________________| 92270 Bois colombes (France)________|

Received on Wed Jul 01 1998 - 01:59:30 CDT