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
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? |