Postgres Pro
Downloads
Home   >   mailing lists

Re: how to replace - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: how to replace
Date
Msg-id 20050909050808.GC9240@webserv.wug-glas.de
Whole thread Raw
In response to how to replace  ("Michael Höller" <MichaelHoeller@t-online.de>)
List pgsql-sql
Tree view 
am  08.09.2005, um 23:25:05 +0200 mailte "Michael Höller" folgendes:
> Hello,
> 
> I initially thought this is simple.. I want to relpace a character to
> nothing. Eg. relace "B" to "" ->  ABCD to ACD.

In the new version 8.1 there are a regex_replace() - function. A other
solution: write your own function with plperl.


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Numeric Columns
Next
From: "Eugene E."
Date:
Subject: Re: a "catch all" type ... such a thing?