Re: Regex on field value

2018-04-14 Thread Adrian Klaver 

On 04/14/2018 02:06 PM, David G. Johnston wrote:
On Saturday, April 14, 2018, Mike Martin > 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.kla...@aklaver.com

Re: Regex on field value

2018-04-14 Thread David G. Johnston 
On Saturday, April 14, 2018, Mike Martin  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.

Regex on field value

2018-04-14 Thread Mike Martin 
Is this possible, eg
Substring(field, regex include other field name)
Thanks