Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5CGwrE53431 for ; Tue, 12 Jun 2001 12:58:53 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f57IwgE59710 for ; Thu, 7 Jun 2001 14:58:42 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f57IcuU35139 for pgsql-sql@postgresql.org; Thu, 7 Jun 2001 14:38:56 -0400 (EDT) (envelope-from news) From: Rene Pijlman X-Newsgroups: comp.databases.postgresql.sql Subject: Re: UPDATE with concatenate Date: Thu, 07 Jun 2001 20:39:29 +0200 Organization: XS4ALL Internet BV Lines: 15 Message-ID: <5hivhtcevimnkklsqq579t2n38asc4bmkf@4ax.com> References: <5.0.2.1.0.20010607185707.00a88e90@172.16.48.1> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@xs4all.nl X-Newsreader: Forte Agent 1.7/32.534 To: pgsql-sql@postgresql.org X-Archive-Number: 200106/185 X-Sequence-Number: 3434 lpatureau@idfr.net (Laurent Patureau) schreef: >UPDATE table SET col .= '$val' Try: UPDATE table set col = col || '$val' http://www.postgresql.org/idocs/index.php?functions-string.html -- Vriendelijke groet, René Pijlman Wat wil jij leren? http://www.leren.nl/