Postgres Pro
Downloads
Home   >   mailing lists

Thread: Regex on field value

Regex on field value

From
Mike Martin
Date:
Is this possible, eg
Substring(field, regex include other field name)
Thanks

Re: Regex on field value

From
"David G. Johnston"
Date:
On Saturday, April 14, 2018, Mike Martin <redtux1@gmail.com> wrote:
Is this possible, eg
Substring(field, regex include other field name)

Your example doesn't make sense but if you are asking whether a regular expression can be stored in a column the answer is yes - though it's nothing but a text value with runtime limitations.

David J.

Re: Regex on field value

From
Adrian Klaver
Date:
On 04/14/2018 02:06 PM, David G. Johnston wrote:
> On Saturday, April 14, 2018, Mike Martin <redtux1@gmail.com 
> <mailto:redtux1@gmail.com>> wrote:
> 
>     Is this possible, eg
>     Substring(field, regex include other field name)

Something like?:

select substring(link_key from '^' || c_id  ), link_key, c_id from 
projection where link_key != 'no_key' limit 10;

  substring |  link_key   |  c_id
-----------+-------------+--------
  6RPLF     | 6RPLF-1646  | 6RPLF
  6RPLF     | 6RPLF-1646  | 6RPLF
  6RPLF     | 6RPLF-1646  | 6RPLF
  6RPLF     | 6RPLF-1646  | 6RPLF
  4RPLF     | 4RPLF-1694  | 4RPLF
  10CEHB    | 10CEHB-2628 | 10CEHB
  10CEHB    | 10CEHB-2628 | 10CEHB
  10CEHB    | 10CEHB-2628 | 10CEHB
  10CEHB    | 10CEHB-1698 | 10CEHB
  1GPLF     | 1GPLF-1704  | 1GPLF
(10 rows)

> 
> 
> Your example doesn't make sense but if you are asking whether a regular 
> expression can be stored in a column the answer is yes - though it's 
> nothing but a text value with runtime limitations.
> 
> David J.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com