Re: UPDATE with concatenate

From: Rene Pijlman <reageer(dot)in(dot)de(dot)nieuwsgroep(at)onzin-adres(dot)nl>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: UPDATE with concatenate
Date: 2001-06-07 18:39:29
Message-ID: 5hivhtcevimnkklsqq579t2n38asc4bmkf@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

lpatureau(at)idfr(dot)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 <rpijlman(at)spamcop(dot)net>

Wat wil jij leren?
http://www.leren.nl/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alla 2001-06-07 18:53:22 Function returning record
Previous Message Stephan Szabo 2001-06-07 17:43:12 Re: UPDATE with concatenate