Regex on field value

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.

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