Joe,
> You have to initialize the array to something non-null, even if that be
> an empty array (note that there is a difference). When trying to append
> an element to a NULL valued array, you wind up with a NULL result. It is
> similar to:
Aha!
I knew that I was missing something fundamental.
BTW, did you get my e-mail to Hackers about ARRAY[] IS NULL?
--
-Josh Berkus
Aglio Database Solutions
San Francisco