X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1098A9FA6B5 for ; Mon, 10 Jul 2006 02:11:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90950-10 for ; Mon, 10 Jul 2006 02:11:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id C864C9FA612 for ; Mon, 10 Jul 2006 02:11:48 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id l23so324126nfc for ; Sun, 09 Jul 2006 22:11:47 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UjTUifI1wjzDHQSMRlu0LPF+tF+VQhNGcSsAqrupBRAHA/R6GdetJwgFJnT9VcCvf6LNhe43lwI/fCJwWgVSN4B/6ZO+rk2+6yrm0nJqY3TE1sIHLUiqeZ7QehgTkIaPJ+WgkE46vlt3Y49+mM6988JGLr5npzfo8RaYFpREbOs= Received: by 10.78.138.14 with SMTP id l14mr1519208hud; Sun, 09 Jul 2006 22:11:47 -0700 (PDT) Received: by 10.78.121.13 with HTTP; Sun, 9 Jul 2006 22:11:47 -0700 (PDT) Message-ID: <9dcb6fa40607092211g5e0e2099x3e6d9d3c56977a02@mail.gmail.com> Date: Mon, 10 Jul 2006 08:11:47 +0300 From: Emils Reply-To: emils.klotins@gmail.com To: pgsql-sql@postgresql.org Subject: Re: SELECT substring with regex In-Reply-To: <44AEC8C5.80103@numerixtechnology.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44AE66E0.1040606@numerixtechnology.de> <200607071659.14940.gary.stainburn@ringways.co.uk> <44AE9B4F.1020401@numerixtechnology.de> <44AEAED9.7080300@myemma.com> <44AEC8C5.80103@numerixtechnology.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/142 X-Sequence-Number: 25716 2006/7/7, T E Schmitz : > > valid entries would be: > "28mm F2.8" (prime lens) > "30-70mm F4" (zoom lens) > "30-70mm F2.8" (zoom lens) > "30-100mm F4.5-5.6" (zoom lens with variable speed) If these are the cases, wouldn't the regex be simply: "^[\d\-]+mm" for BASE "^[\d\-]+mm (.+)$" for SUFFIX Or are you having to deal with malformatted data too (like "30 -70mm" or "28 mm ")? Emils