Received: from astro.phpwebhosting.com (astro.phpwebhosting.com [66.33.60.221]) by postgresql.org (8.11.3/8.11.4) with SMTP id f9IG3xP76841 for ; Thu, 18 Oct 2001 12:03:59 -0400 (EDT) (envelope-from frampton@LinuxNinja.com) Received: (qmail 3107 invoked by uid 722); 18 Oct 2001 16:03:33 -0000 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 18 Oct 2001 16:03:33 -0000 Date: Thu, 18 Oct 2001 12:03:28 -0400 (EDT) From: Steve Frampton X-X-Sender: To: Subject: Doing a regexp-based search/replace? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200110/253 X-Sequence-Number: 5208 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello: I've got a table containing property_id's with values of the form ###-####. I would like to discard the slash onwards (and I can't use a substr() because I am not guaranteed if a) the -#### portion exists, b) what position it exists from. If this were a text file, I would use a sed expression such as: cat textfile | sed 's/-.*$//' I've been looking for a way to do this with PostgreSQL but so far haven't found a function that seems to be suitable. I thought maybe I could do it with translate, but translate doesn't appear to work with regular expressions. So far I've tried things like: select translate(property_id, '-.*', '') from mytable; I need to do this, because the -.* portion of my property_id was entered in error, and I would like to do an update on the entire table and just have the left-hand side of the property_id column remaining. Any ideas? Thank you in advance. - ---------------< LINUX: The choice of a GNU generation. >------------- Steve Frampton http://www.LinuxNinja.com GNU Privacy Guard ID: D055EBC5 (see http://www.gnupg.org for details) GNU-PG Fingerprint: EEFB F03D 29B6 07E8 AF73 EF6A 9A72 F1F5 D055 EBC5 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.0 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7zv1TmnLx9dBV68URAisEAJ4nNYz4lxpgWojULE/Xo9SUb5IexgCfS9At J6kAVn/3vFHeJkl9bjr4AcQ= =W4xQ -----END PGP SIGNATURE-----