Search Postgresql Archives

Re: Array intersection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Oct 17, 2007 at 01:00:48PM -0500, Josh Trutwin wrote:
> Works like a champ on 8.1.
> 
> Thanks!

That's OK, it was a good learning experience.

> Did you see David Fetter's reply to the original post?  He has
> an interesting alternative.

I did, it's much more elegant.  I've never seen generate_series used
like that, it's a very nice way of doing things.  If your arrays are
ever more than a few elements long his is probably going to be much
faster.  Generally for less than 6 or 7 elements it's better doing the
naive thing, not sure if that applies here though.


  Sam

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux