[GENERAL] Array manipulation/syntax question

[Bart Grantham]

Hello again.  I had a problem a few weeks ago with using IN ( some_array 
) having really rough performance.  Special thanks to Ron Mayer for the 
suggestion of using int_array_enum(some_array) to join against.  I had 
to upgrade to PG8 but that technique works really well.  Now I have a 
question about array manipulation.  Specifically, how can I build an 
array from the result of a query without resorting to array_append()?  I 
have a recursive function that passes itself an array each time and I 
want to build this array by taking a column out of a query (which is a 
join from the input array and a table... see?  recursive!).  This 
becomes a performance issue since the query tha wraps array_append could 
be returning many thousands of rows.  Hmm, my question is sounding more 
complicated it should.  Let me put it this way... how do I do this:

-- my_array is an INT[]
_my_array := select some_column from some_table;
... in plpgsql?
Thanks in advance.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings