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 ________________________________________________________________