[GENERAL] Concat bigint Array Values in a Function

Hi, I need to optimise and aggregate array integer values in a function and i am doing this by below stored function : -- type def CREATE TYPE fun_type AS ( g_id integer, zip_id_list integer[], city_id_list integer[], state_id_list integer[],

Re: [GENERAL] Concat bigint Array Values in a Function

Vinay Gupta wrote Please let me know if there is any optimal way to finish this function in ~ 2-3 secs If you can figure out how to write that in pure SQL you might have a chance. David J. -- View this message in context:

Re: [GENERAL] Concat bigint Array Values in a Function

Table A : 220 MB Table B : 120 KB Yeah figuring out how to write it in pure SQL. Thanks On Tue, Nov 11, 2014 at 6:15 AM, David G Johnston david.g.johns...@gmail.com wrote: Vinay Gupta wrote Please let me know if there is any optimal way to finish this function in ~ 2-3 secs If you