Thanks Ross,
Sorry I didn't come with an example but I meant something like:
test=> create table test_text (word_id int, words text);
CREATE
test=> insert into test_text values (1, 'some text');
INSERT 684150 1
test=> UPDATE test_text SET words = words + 'some more text' WHERE word_id = 1;
Resulting in:
test=> SELECT * FROM test_text;
word_id|words
-------+---------------
1|some text some more text
Hope this explains my question.
Thanks.
"Ross J. Reedstrom" wrote:
> On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote:
> >
> > Now I use php3 to read the text from the database then I append some
> > text to it and finaly I do an update on the text field.
> > Is it possible to use an SQL statement to do this directly in the
> > database?
> >
>
> Like this?
>
> test=> create table test_text (word_id int, words text);
> CREATE
> test=> insert into test_text values (1, 'some text');
> INSERT 684150 1
> test=> insert into test_text values (2, 'some other text');
> INSERT 684151 1
> test=> select * from test_text;
> word_id|words
> -------+---------------
> 1|some text
> 2|some other text
> (2 rows)
>
> test=> update test_text set words = textcat(words,', and text added later') where
>word_id=1;
> UPDATE 1
> test=> select * from test_text;word_id|words
> -------+-------------------------------
> 2|some other text
> 1|some text, and text added later
> (2 rows)
>
> test=>
>
> Ross
> --
> Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
> NSBRI Research Scientist/Programmer
> Computer and Information Technology Institute
> Rice University, 6100 S. Main St., Houston, TX 77005
begin:vcard
n:Aarts;Wim
tel;cell:06-20598154
tel;fax:0493-351319
tel;work:0493-351320
x-mozilla-html:TRUE
url:www.dsdeurne.nl
org:DSDeurne Automatisering;Development
adr:;;Dr. Hub v. Doorneweg 14;Deurne;;5750 AG;Nederland
version:2.1
email;internet:[EMAIL PROTECTED]
title:ir
note;quoted-printable:Algemeen e-mail adres:[EMAIL PROTECTED]
fn:Wim Aarts
end:vcard
