From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
---|---|
To: | "PostgreSQL (SQL)" <pgsql-sql(at)postgresql(dot)org> |
Subject: | UPDATE Multiple Records At Once? |
Date: | 2012-04-11 17:50:25 |
Message-ID: | CAAQLLO5HwMETX31_jpT2U=HtoqW1gGkc8+qAE5xUMOmGAQTT4g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I'm trying to update a customer record in a table however I need to
change several values (cust_address, cust_contact, cust_email). My
question is how do I properly format this into one single command?
forza=# SELECT cust_id, cust_name, cust_address, cust_contact, cust_email
forza-# FROM customers
forza-# WHERE cust_name = 'iamUNIX'
forza-# ;
cust_id | cust_name | cust_address | cust_contact |
cust_email
------------+-----------+-----------------------+----------------+--------------------
1000000006 | MobileNX | 200 South Shore Drive | Carlos Mennens |
carlos(at)mobilenx(dot)com
(1 row)
I did a quick Google search and I can see there is a method or
procedure which involves parenthesis () however I'm not sure how I
would change all the values listed above under one command. Can anyone
please give me a quick example so I can see how this is drawn out via
ANSI SQL?
From | Date | Subject | |
---|---|---|---|
Next Message | lewbloch | 2012-04-11 19:20:42 | Re: UPDATE Multiple Records At Once? |
Previous Message | yeison garcia | 2012-04-11 17:42:37 | Re: Pregunta acerca de la función COPY de POSTGRES |