On Wed, Dec 9, 2015 at 1:16 PM, Michael Moore <michaeljmoore@gmail.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,MikeSELECT '1' = ANY(string_to_array('1,2,3,4,5', ','))David J.
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
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных