Received: from symcom.com ([209.11.41.82]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1O2Hhx35303 for ; Fri, 23 Feb 2001 21:17:43 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200102240217.f1O2Hhx35303@mail.postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Fri, 23 Feb 2001 21:24:35 -0500 Date: Fri, 23 Feb 2001 21:24:35 -0500 From: "postgresql" To: "PgSQL-SQL" Subject: syntax prob X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200102/372 X-Sequence-Number: 1573 I am away from my server for the weekend and I need a little help. when doing updates of multiple fields there commas between the elements? I mean update table set cname = 'Bill', caddress = '2nd floor' where acode = 'AVAN'; I refer to the space between 'Bill' and caddress. if I could get to the server I would just try it. what happens if you have only 1 field to update and you add a comma, like this update table set cname = 'Bill', where acode = 'AVAN'; I am trying to concatenate an update string and I would love to not have to worry about the comma. I guess I could figure out how many things have changed then add commas... but I could also wish for it to be easier. Ted