Re: BUG #3641: Concat fails in update

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3641: Concat fails in update
Date: 2007-09-28 13:46:23
Message-ID: fdj0jp$9n9$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Curt написа:
> 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'.

Is this the real statement you've used? Because it's not a valid UPDATE
statement - it's missing the 'SET' part before the name of the column.
Could you send the real statement _and_ the error message you've got.

--
Milen A. Radev

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-09-28 13:46:32 Re: BUG #3641: Concat fails in update
Previous Message Curt 2007-09-28 13:39:18 BUG #3641: Concat fails in update