Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE with concatenate - Mailing list pgsql-sql

From Rene Pijlman
Subject Re: UPDATE with concatenate
Date
Msg-id 5hivhtcevimnkklsqq579t2n38asc4bmkf@4ax.com
Whole thread Raw
In response to UPDATE with concatenate  (Laurent Patureau <lpatureau@idfr.net>)
List pgsql-sql
Tree view 
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 <rpijlman@spamcop.net>

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

pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: Re: need help please on triggers..
Next
From:
Date:
Subject: Re: Getting row with id=max(id)