UPDATE Multiple Records At Once?

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?

Responses

Browse pgsql-sql by date

  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