Обсуждение: Regex on field value
Is this possible, eg
Substring(field, regex include other field name)
Thanks
On Saturday, April 14, 2018, Mike Martin <redtux1@gmail.com> wrote:
Is this possible, egSubstring(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