pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUPDATE with concatenate
3+ messages / 3 participants
[nested] [flat]
* UPDATE with concatenate
@ 2001-06-07 17:14 Laurent Patureau <lpatureau@idfr.net>
2001-06-07 17:43 ` Re: UPDATE with concatenate Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-06-07 18:39 ` Re: UPDATE with concatenate Rene Pijlman <reageer.in.de.nieuwsgroep@onzin-adres.nl>
0 siblings, 2 replies; 3+ messages in thread
From: Laurent Patureau @ 2001-06-07 17:14 UTC (permalink / raw)
To: pgsql-sql
Hy,
I try to update a table:col with take the valueof this col and concatenate
it with $val.
I don't want to select all value of table:col and addition $val at each one
I try :
UPDATE table SET col .= '$val'
But it doesn't work, any suggestion ?
pat
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: UPDATE with concatenate
2001-06-07 17:14 UPDATE with concatenate Laurent Patureau <lpatureau@idfr.net>
@ 2001-06-07 17:43 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
1 sibling, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2001-06-07 17:43 UTC (permalink / raw)
To: Laurent Patureau <lpatureau@idfr.net>; +Cc: pgsql-sql
Maybe this?
update table set col = col || '$val';
On Thu, 7 Jun 2001, Laurent Patureau wrote:
> Hy,
>
> I try to update a table:col with take the valueof this col and concatenate
> it with $val.
> I don't want to select all value of table:col and addition $val at each one
>
> I try :
>
> UPDATE table SET col .= '$val'
>
> But it doesn't work, any suggestion ?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: UPDATE with concatenate
2001-06-07 17:14 UPDATE with concatenate Laurent Patureau <lpatureau@idfr.net>
@ 2001-06-07 18:39 ` Rene Pijlman <reageer.in.de.nieuwsgroep@onzin-adres.nl>
1 sibling, 0 replies; 3+ messages in thread
From: Rene Pijlman @ 2001-06-07 18:39 UTC (permalink / raw)
To: pgsql-sql
lpatureau@idfr.net (Laurent Patureau) schreef:
>UPDATE table SET col .= '$val'
Try:
UPDATE table set col = col || '$val'
http://www.postgresql.org/idocs/index.php?functions-string.html
--
Vriendelijke groet,
René Pijlman <rpijlman@spamcop.net>
Wat wil jij leren?
http://www.leren.nl/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-06-07 18:39 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-07 17:14 UPDATE with concatenate Laurent Patureau <lpatureau@idfr.net>
2001-06-07 17:43 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-06-07 18:39 ` Rene Pijlman <reageer.in.de.nieuwsgroep@onzin-adres.nl>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox