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