X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EE4AFD9EA1 for ; Mon, 3 Oct 2005 19:08:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50853-05 for ; Mon, 3 Oct 2005 22:08:30 +0000 (GMT) Received: from resolution.com (unknown [65.18.201.170]) by svr1.postgresql.org (Postfix) with ESMTP id 8FE62D9ED1 for ; Mon, 3 Oct 2005 19:08:30 -0300 (ADT) Received: (from resolutio@localhost) by resolution.com (8.12.10/8.11.2) id j93M8UYn021934; Mon, 3 Oct 2005 18:08:30 -0400 From: gurkan@resolution.com X-Authentication-Warning: resolution.com: resolutio set sender to gurkan@resolution.com using -f To: pgsql-sql@postgresql.org Subject: regular expression Message-ID: <1128377310.4341abde55776@www.resolution.com> Date: Mon, 03 Oct 2005 18:08:30 -0400 (EDT) Cc: gurkan@resolution.com MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.8 X-Originating-IP: 216.63.139.105 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.38 required=5 tests=[AWL=0.152, FORGED_RCVD_HELO=0.05, NO_REAL_NAME=0.178] X-Spam-Level: X-Archive-Number: 200510/20 X-Sequence-Number: 22873 How do I do regular expression for the problem that I am having I have a string called desc, and say that this string in "TSWUU" ------ "" "4 - DSC" ------ "4" "6768 - THY" ------ "6768" basically string may or may not start with number, I need substring of digits parts "" "4" "6768" ------------------------------------------------- This mail sent through IMP: www.resolution.com