Received: from mail.noos.fr (descartes.noos.net [212.198.2.74]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f57HClE16667 for ; Thu, 7 Jun 2001 13:12:47 -0400 (EDT) (envelope-from lpatureau@idfr.net) Received: (qmail 3281573 invoked by uid 0); 7 Jun 2001 17:12:45 -0000 Received: from r29m221.cybercable.tm.fr (HELO idfr2.idfr.net) ([195.132.29.221]) (envelope-sender ) by descartes.noos.net (qmail-ldap-1.03) with SMTP for ; 7 Jun 2001 17:12:45 -0000 Message-Id: <5.0.2.1.0.20010607185707.00a88e90@172.16.48.1> X-Sender: lpatureau@172.16.48.1 X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Thu, 07 Jun 2001 19:14:18 +0200 To: pgsql-sql@postgresql.org From: Laurent Patureau Subject: UPDATE with concatenate Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200106/109 X-Sequence-Number: 3329 Hy, I try to update a table:col with take the valueof this col and concatenate it with $val. I don't want to select all value of table:col and addition $val at each one I try : UPDATE table SET col .= '$val' But it doesn't work, any suggestion ? pat