UPDATE with concatenate

From: Laurent Patureau <lpatureau(at)idfr(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: UPDATE with concatenate
Date: 2001-06-07 17:14:18
Message-ID: 5.0.2.1.0.20010607185707.00a88e90@172.16.48.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-07 17:31:34 Re: Getting row with id=max(id)
Previous Message jeff 2001-06-07 17:04:02 Re: Getting row with id=max(id)