Re: Array intersection - Mailing list pgsql-general

From Sam Mason
Subject Re: Array intersection
Date
Msg-id 20071017211632.GP10098@samason.me.uk
Whole thread Raw
In response to Re: Array intersection  (Josh Trutwin <josh@trutwins.homeip.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Ken Johansson"
Date:
Subject: downloading and installing postgreSQL
Next
From: Guy Rouillier
Date:
Subject: Re: downloading and installing postgreSQL