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

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: "Rajan, Pavithra" <RAJANP(at)coned(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help on updating an entire column with a list of values, I have.
Date: 2010-03-26 14:14:48
Message-ID: e4edc9361003260714tfa297dfjafed95eb916aac93@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/3/26 Rajan, Pavithra <RAJANP(at)coned(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rajan, Pavithra 2010-03-26 14:16:48 Re: Need help on updating an entire column with a list of values, I have.
Previous Message Ozz Nixon 2010-03-26 14:14:15 Re: Does anyone use in ram postgres database?