In comp.databases.postgresql.general Peter Eisentraut <peter_e@gmx.net> wrote:
> postgres@athena.frontlogic.com writes:
>> I assume using the array type would save me some cost on storage, while
>> using the varchar/integer pairs would result in faster queries. Is this
>> correct? Thanks for any help or pointers.
> As long as you don't want to look up or join against invidual array
> members, the array solution is going to be more space and time efficient.
Thanks for the reply. I am going to join on individual members, so I will shy away
from array types. I'm uncomfortable with array types in general, because of their
deviance from the relational model. Does anyone have any links to a discussion of
the pros and cons of using array types?