Updating multiple fields

Joao Paulo Felix <felix@cyclades.com>

From: Joao Paulo Felix <felix@cyclades.com>
To: "pgsql-general@postgreSQL.org" <pgsql-general@postgreSQL.org>
Date: 1998-06-26T17:20:38Z
Lists: pgsql-general, pgsql-sql
Hello there, 

I have the following fields description, info and title.
Is there a PostgreSQL query to update more than one field at the same
time? 

Right now I have the following (I am using it with PHP, so please
desregard its code):

pg_Exec($conn, "UPDATE options SET description = '$description' 
	WHERE product = '$product' AND title = '$old_title';");

pg_Exec($conn, "UPDATE options SET info = '$info' 
	WHERE product = '$product' AND title = '$old_title';");

pg_Exec($conn, "UPDATE options SET title = '$title' 
	WHERE product = '$product' AND title = '$old_title';");

Ultimately I would like to have one single query. Is it possible?

Thanks in advance for your help/pointers.

Regards,

JP

-- 
________________________________________________________________

Joao Paulo Felix 
Interactive Media Coordinator

Cyclades Corporation                    voice: (510) 770-9727
41934 Christy Street                    fax: (510) 770-0355
Fremont, CA                             www.cyclades.com
________________________________________________________________