Allow Reg Expressions in Position function

From: Nick Dro <postgresql(at)walla(dot)co(dot)il>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Allow Reg Expressions in Position function
Date: 2018-08-20 06:25:31
Message-ID: ^3B698E60032749E5D9839AF70A7F5B3CF3E241BC@walla.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div dir='rtl'><div dir="ltr">Position function allows only string as pattern parameter:</div>
<div dir="ltr">&nbsp;</div>
<div dir="ltr">select position(sub-string in string)</div>
<div dir="ltr">&nbsp;</div>
<div dir="ltr">If you are looking for more than one sub-string you can't do it with a single call to position.</div>
<div dir="ltr">More info:&nbsp;</div>
<div dir="ltr"><a href="https://stackoverflow.com/questions/51925037/how-to-find-position-of-multiple-sub-string-in-postgresql">https://stackoverflow.com/questions/51925037/how-to-find-position-of-multiple-sub-string-in-postgresql</a></div>
<div dir="ltr">&nbsp;</div>
<div dir="ltr">&nbsp;</div>
<div dir="ltr">Required solution: make&nbsp;sub-string accept regular expression just like the LIKE operator.</div></div>

Attachment Content-Type Size
unknown_filename text/html 786 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-08-20 07:03:17 Re: including header files in a C extension
Previous Message Achilleas Mantzios 2018-08-20 06:08:39 Re: Audit management