@lespauled, suit yourself. You have been of no help whatsoever so far. And I think this is due to both of you having missed a crucial aspect of my post. Both the title and the tag specifies that this is a PostgreSQL specific question. Arrays exist as a data type in PostgreSQL. I can create arrays without even needing to bother about tables. So all this talk about tables and their structure is actually irrelevant to my question.
8.15.4 shows examples of how you can use SQL with arrays in PostgreSQL without even needing tables.