am 01.11.2005, um 13:01:54 -0500 mailte DEV folgendes: > Currently I am running 8.0.1. Looks like an upgrade is in my future. Oh > Joy!!!! LOL > > am 31.10.2005, um 13:11:20 -0500 mailte DEV folgendes: > > Is is possible to use replace along with regular expression to remove any > > and all punctuation from a field? > > Which version? > > PG 8.1 have a function 'regex_replace'. Other solution: use plpgperl to use regex-functions. Btw.: http://www.vranx.de/mail/tofu.html HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
