Re: Array with Subselect / ANY - cast? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Array with Subselect / ANY - cast?
Date
Msg-id E7112DAD-4B81-4CEA-9865-A178949B0309@seespotcode.net
Whole thread Raw
In response to Re: Array with Subselect / ANY - cast?  (Josh Trutwin <josh@trutwins.homeip.net>)
List pgsql-general
On Aug 21, 2007, at 14:35 , Josh Trutwin wrote:

> it's a simple example but the number of list-type
> fields is anticipated to be VERY high so I decided to deal with
> arrays instead of creating all sorts of normalized tables.
> Was it the right thing to do?

No offense, but I doubt it. This doesn't seem to be a very good
reason to move away from normal database practices. As I previously
mentioned, you're throwing referential integrity out the window. Do
things right unless you have a measurable reason to do things another
way. Sounds like premature optimization to me, so all the normal
rules of premature optimization apply.

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: reporting tools
Next
From: "Joshua D. Drake"
Date:
Subject: Re: reporting tools