Re: UPDATE with concatenate - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: UPDATE with concatenate
Date
Msg-id Pine.BSF.4.21.0106071042420.21982-100000@megazone23.bigpanda.com
Whole thread Raw
In response to UPDATE with concatenate  (Laurent Patureau <lpatureau@idfr.net>)
List pgsql-sql
Maybe this?
update table set col = col || '$val';

On Thu, 7 Jun 2001, Laurent Patureau wrote:

> 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 ?



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Are SQL commands "atomic" ?
Next
From: Gerald Gutierrez
Date:
Subject: Re: Are SQL commands "atomic" ?