What you want is called UNNEST. It didn't get done in time for 8.0. But if
what you have is an array of integers the int_array_enum() function I quoted
in the other post is basically that.

Yes, I used it, thanks. That's what I wanted. The query plans are good.

You don't really need the int_array_aggregate function any more. You can write
your own aggregate using the new array operators:
Of course it's about 50x slower than the C implementation though:

Heh. I'll keep using int_array_aggregate ;)

        Have a nice day.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to