Design question: Using Array datatypes - Mailing list pgsql-general

From Mr. Tomcat
Subject Design question: Using Array datatypes
Date
Msg-id 1032840872.11707.1087.camel@mobile
Whole thread Raw
Responses Re: Design question: Using Array datatypes  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
I noticed that PG supports arrays.  I noticed also that one of the rules
of DB normalization is "no repeating fields".  It seems like using
arrays would violate that.  I have a particular need that would benefit
from using arrays.  There will be no need to search elements in the
array, so it seems like a good place to use it.  What are opinions on
array usage?  Is it a horrible misfeature, never to be used, or is it
the right way to go in some situations?  I have never used arrays in a
db design.

Thanks for an opinions on this.


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: DBLink: interesting issue
Next
From: Oleg Bartunov
Date:
Subject: Re: Design question: Using Array datatypes