From: Emils <gnudiff@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: SELECT substring with regex
Date: Mon, 10 Jul 2006 08:11:47 +0300
Message-ID: <9dcb6fa40607092211g5e0e2099x3e6d9d3c56977a02@mail.gmail.com> (raw)
In-Reply-To: <44AEC8C5.80103@numerixtechnology.de>
References: <44AE66E0.1040606@numerixtechnology.de>
<200607071659.14940.gary.stainburn@ringways.co.uk>
<44AE9B4F.1020401@numerixtechnology.de>
<44AEAED9.7080300@myemma.com>
<44AEC8C5.80103@numerixtechnology.de>
2006/7/7, T E Schmitz <mailreg@numerixtechnology.de>:
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gnudiff@gmail.com
Subject: Re: SELECT substring with regex
In-Reply-To: <9dcb6fa40607092211g5e0e2099x3e6d9d3c56977a02@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox