Curt написа:
> 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'.
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
