>>> On Fri, Sep 28, 2007 at 8:39 AM, in message
<[EMAIL PROTECTED]>, "Curt"
<[EMAIL PROTECTED]> wrote:
> UPDATE table content=content || 'constant' where idx=101;
>
> Content field is overwritten with 'constant'.
test=> create temp table t1 (idx int not null primary key, content text);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for
table "t1"
CREATE TABLE
test=> insert into t1 values (1, 'one');
INSERT 0 1
test=> update t1 set content = content || ' and a half' where idx = 1;
UPDATE 1
test=> select * from t1;
idx | content
-----+----------------
1 | one and a half
(1 row)
test=> select version();
version
-------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE
Linux)
(1 row)
Please show something similar from your environment.
-Kevin
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
