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.

Hi again,

 

are there oids in your table or do you have any possibility to assure the mentioned order of your data lines when you do a select?

 

If you can assure the order, you could use the temp table solution mentioned by Grzegorz Jaśkiewicz.

 

If you cannot assure the order this could get tricky…

 

Mit freundlichen Grüßen

Timo Klecker

 

 

 

Von: Rajan, Pavithra [mailto:RAJANP@xxxxxxxxx]
Gesendet: Freitag, 26. März 2010 15:17
An: Timo Klecker; pgsql-general@xxxxxxxxxxxxxx
Betreff: RE: 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