Curt wrote:
> The following bug has been logged online:
> 
> Bug reference:      3641
> Logged by:          Curt
> Email address:      [EMAIL PROTECTED]
> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to