Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: BUG #3641: Concat fails in update


  • From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
  • To: Curt <kurt(at)net2business(dot)com>
  • Cc: pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: BUG #3641: Concat fails in update
  • Date: Fri, 28 Sep 2007 14:46:32 +0100
  • Message-id: <46FD05B8.80207@enterprisedb.com> <text/plain>

Curt wrote:
> The following bug has been logged online:
> 
> Bug reference:      3641
> Logged by:          Curt
> Email address:      kurt(at)net2business(dot)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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group