Postgres Pro
Downloads
Home   >   mailing lists

Re: Concat bigint Array Values in a Function - Mailing list pgsql-general

From Vinay Gupta
Subject Re: Concat bigint Array Values in a Function
Date
Msg-id CAEzDN6zySTvNDsE17qY0k6Ge89_aFjb6wW=-9v=aufmkHWuuew@mail.gmail.com
Whole thread Raw
In response to Re: Concat bigint Array Values in a Function  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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.johnston@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 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-Function-tp5826428p5826433.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Updating timezone setting
Next
From: Ilya Ashchepkov
Date:
Subject: Re: justify_interval: days in year