pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
UPDATE 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