From: | Glenn Schultz <glenn(at)bondlab(dot)io> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: query with regular expression |
Date: | 2019-01-03 20:31:16 |
Message-ID: | CAE-4=KE-UUX_LniyCfAbKoyHfviB-fUn=SSuXuwn7Ds055t9Qw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the tip!
On Thu, Jan 3, 2019 at 12:58 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Thursday, January 3, 2019, Glenn Schultz <glenn(at)bondlab(dot)io> wrote:
>
>> All,
>>
>> I am writing a query to select * from where ~ '[regx] an example of the
>> sting that I am matching is below
>>
>> FHLG16725
>>
>> The first two alpha characters to match are FN, FH, GN any alpha
>> characters between those and the numeric don't matter as the first two
>> alpha + numeric will create a unique.
>>
>> reading the docs I am pretty sure I need to use ~ for bracket expression
>>
>> I tried '^[FN-FG-GN][0-9]' but does not seem to work. I have to admit I
>> am weak on regex - never quite seem to be able to get it through my coconut.
>>
>
> Yeah...that’s not even close...not exactly sure what it would match but
> it’s only two characters, one letter maybe and one number. You seem to
> want capturing groups though so using the ~ operator isn’t going to work,
> you need to use the function.
>
>
>>
>> Any help would be appreciated,
>> Glenn
>>
>
> ~ ‘^(FN|FH|GN)[A-Z]*[0-9]+$’
>
> David J.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-01-03 20:38:14 | Re: Memory exhaustion due to temporary tables? |
Previous Message | David G. Johnston | 2019-01-03 18:58:45 | Re: query with regular expression |