From: A. Kretschmer <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: how to do a find and replace
Date: Fri, 18 Nov 2005 07:15:48 +0100
Message-ID: <20051118061548.GB15746@webserv.wug-glas.de> (raw)
In-Reply-To: <c051e0b633ba9015ecd98f6c038783e0@squeegeemedia.com>
References: <c051e0b633ba9015ecd98f6c038783e0@squeegeemedia.com>
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;
loc
-------------------
/0/v.myimage.jpg
(1 row)
test=# update foo set loc = regexp_replace(loc, '/v\.', '/');
UPDATE 1
test=# select * from foo;
loc
-----------------
/0/myimage.jpg
(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 http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas.kretschmer@schollglas.com
Subject: Re: how to do a find and replace
In-Reply-To: <20051118061548.GB15746@webserv.wug-glas.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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