Community

PostgreSQL 8.4 Faster array building with array_agg

(Leo Hsu and Regina Obe) One of the very handy features introduced in PostgreSQL 8.4 is the new aggregate function called array_agg which is a companion function to the unnest function we discussed earlier. This takes a set of elements similar to what COUNT, SUM etc do and builds an array out of the

Read More - Register for Free Membership