title: how to use NOT LIKE with result from query as pattern
body: <p>I have these two tables
  1 -</p>
  <pre><code>drop table if exists random_data;
  
  
  create table random_data (
      name text,
      discription text
  )
  ;
  
  insert into random_data values ('david' , 'runner'),
                                  ('mosh' , 'walker'),
                                  ('ran' , 'sweemer'),
                                  ('joh' , 'diver');
  </code></pre>
  <p>and the second</p>
  <pre><code>DROP TABLE IF EXISTS filter_test ;
  CRATE TABLE filter_test (
      config_key text,
      config_value text
  );
  INSERET INTO filter_test select 'BLACKLIST_NAMES' , 'david,ran';
  INSERET INTO filter_test select 'FILTER' , 'di,ja,aap';
  </code></pre>
  <p>I want to write a query the give me back the name from <code>random_data</code> that are not in <code>BLACKLIST_NAMES</code> from <code>filter_test</code> table and there <code>discription</code> not contained part of the pattern from <code>FILTER</code>
  I was able to complete the first part like this:</p>
  <pre><code>SELECT* from random_data where  name not in (with t as (
      SELECT
          max(case when config_key = 'BLACKLIST_NAMES' then config_value::text end) as names_blacklist
  --      max(case when config_key = 'BLACKLIST_NAME_FILTERS' then config_value::text end) as BLACKLIST_NAME_FILTERS
      from filter_test
  )
  select 
      regexp_split_to_table(names_blacklist, ',') as names
  from t
  ) order by name;
  </code></pre>
  <p>but I'm unable to complete the second part,
  I tried like this:</p>
  <pre><code>select  * from random_data where  name not in (with t as (
      select  
          max(case when config_key = 'BLACKLIST_NAMES' then config_value::text end) as names_blacklist        
      from filter_test
  )
  select 
      regexp_split_to_table(names_blacklist, ',') as names
  from t
  )   and  discription not like (with t as (
      select  
          max(case when config_key = 'BLACKLIST_NAME_FILTERS' then config_value::text end) as filters
      from filter_test
  )
  select 
      regexp_split_to_table(filters, ',') as filter
  from t
  )order by name
  </code></pre>
  <p>expected output</p>
  <pre><code>**name**    **discription**
    mosh          walker
  </code></pre>