Re: Need help on updating an entire column with a list of values, I have. - Mailing list pgsql-general

From Szymon Guz
Subject Re: Need help on updating an entire column with a list of values, I have.
Date
Msg-id e4edc9361003260714tfa297dfjafed95eb916aac93@mail.gmail.com
Whole thread Raw
In response to Need help on updating an entire column with a list of values, I have.  ("Rajan, Pavithra " <RAJANP@coned.com>)
List pgsql-general


2010/3/26 Rajan, Pavithra <RAJANP@coned.com>

Hello - I have this table with 90 rows, which contains 2 columns ,column A (type 'numeric') and column B(type text) . Column 'A' is filled with a constant number and column 'B' has an unique entry for each row.

E.g.              A                 B
         (numeric)        (text)
           
            15968.0           002
        15968.0           003
        15968.0           004
        15968.0           011
        15968.0           012
        15968.0           057
        15968.0           006
        15968.0           009
        15968.0           010
             ..
             .. 
I would here want to update the entire column A with a list of values that I have.( 06959.0,15308.0,15968.0,18916.2,19961.0,26528.0,29553.0,29872.0,30631.0 …).How do I accomplish this? Thank you.

         


Hi,
what is the relation between current data and the data that you have in the list? How do you want to update those values? Where should be the value 06959.0 and where 29872.0?

regards
Szymon Guz

pgsql-general by date:

Previous
From: Ozz Nixon
Date:
Subject: Re: Does anyone use in ram postgres database?
Next
From: "Rajan, Pavithra "
Date:
Subject: Re: Need help on updating an entire column with a list of values, I have.