Re: BUG #3641: Concat fails in update - Mailing list pgsql-bugs

Curt wrote:
> The following bug has been logged online:
>
> Bug reference:      3641
> Logged by:          Curt
> Email address:      kurt@net2business.com
> PostgreSQL version: 8.1.9-1.el5
> Operating system:   Centos 5
> Description:        Concat fails in update
> Details:
>
> UPDATE table content=content || 'constant' where idx=101;
>
> Content field is overwritten with 'constant'.

You're missing a SET.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com