| From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Array intersection |
| Date: | 2007-10-17 21:16:32 |
| Message-ID: | 20071017211632.GP10098@samason.me.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Rouillier | 2007-10-17 21:17:08 | Re: downloading and installing postgreSQL |
| Previous Message | Ken Johansson | 2007-10-17 21:06:39 | downloading and installing postgreSQL |