CVS to In_list without dynamic SQL, how?

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: CVS to In_list without dynamic SQL, how?
Date: 2015-12-09 20:16:40
Message-ID: CACpWLjNEXOUqw3iriw4FBdLEjbi20mGt0aeKN9Yc-kDpCBwZhA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2015-12-09 20:19:38 Re: CVS to In_list without dynamic SQL, how?
Previous Message Michael Moore 2015-12-08 20:55:54 Re: call by reference vs call by value