On Wed, Dec 9, 2015 at 1:16 PM, Michael Moore <michaeljmoore(at)gmail(dot)com>
wrote:
> DO $$declare
> csv text := '''1'',''2'',''3''';
> v_var text;
> begin
> select var into v_var from tx_vendor where vendor_key in csv;
> RAISE NOTICE 'result=(%)', v_var ;
> end$$;
>
> Obviously the above does not work, but hopefully explain what I am trying
> to accomplish.
> Thanks,
> Mike
>
>
SELECT '1' = ANY(string_to_array('1,2,3,4,5', ','))
David J.