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