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
>
>
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:
http://postgresql.nabble.com/Concat-bigint-Array-Values-in-a-Fun
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[],
lat_long_id_li
