Skip site navigation (1) Skip section navigation (2)

Re: how to do a find and replace

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to do a find and replace
Date: 2005-11-18 06:15:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
am  17.11.2005, um 14:51:05 -0800 mailte Dawn Buie folgendes:
> Hello-
> I have a column of data with the wrong prefix for many items.

If you have 8.1? If yes:

> The wrong entries are entered ' /0/v.myimage.jpg'
> While the correct ones are ' /0/myimage.jpg'
> I need to remove all the 'v.' characters from this column.a

test=# select * from foo;
(1 row)

test=# update foo set loc = regexp_replace(loc, '/v\.', '/');
test=# select * from foo;
(1 row)

If no:

a) Upgrade now!
b) write a funcion with plperl for the regexp_replace

HTH, Andreas
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C
 ===    Schollglas Unternehmensgruppe    === 

In response to

pgsql-sql by date

Next:From: Andy BallingallDate: 2005-11-18 09:09:24
Subject: Re: idea for a geographically distributed database: how best to implement?
Previous:From: Aftab AlamDate: 2005-11-18 05:25:24
Subject: query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group