Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: Need help on updating an entire column with a list of values, I have.
Hello ,
     Yes -I need to get the exact  the same result as you had listed.Thanks.


From: Timo Klecker [mailto:klecker@xxxxxxxxx]
Sent: Friday, March 26, 2010 10:12 AM
To: Rajan, Pavithra ; pgsql-general@xxxxxxxxxxxxxx
Subject: AW: Need help on updating an entire column with a list of values, I have.

Hello,

 

what do you expect as Result? Something like this?

 

E.g.              A                 B
         (numeric)        (text)
           
           06959.0           002
       15308.0           003
       15968.0           004
       18916.0           011
       19961.0           012
       26528.0           057
       29553.0           006
       29872.0           009
       30631.0           010

 

Mit freundlichen Grüßen

Timo Klecker

 

 

Von: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Rajan, Pavithra
Gesendet: Freitag, 26. März 2010 14:48
An: pgsql-general@xxxxxxxxxxxxxx
Betreff: Need help on updating an entire column with a list of values, I have.

 

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.

         
   


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux