UPDATE with concatenate - Mailing list pgsql-sql

From Laurent Patureau
Subject UPDATE with concatenate
Date
Msg-id 5.0.2.1.0.20010607185707.00a88e90@172.16.48.1
Whole thread Raw
Responses Re: UPDATE with concatenate
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Gerald Gutierrez
Date:
Subject: Are SQL commands "atomic" ?
Next
From: Peter Eisentraut
Date:
Subject: Re: Getting row with id=max(id)