Re: By The Dawn's Normal Light

"Kenneth Downs" <firstinit.lastname_at_lastnameplusfam.net> wrote in message news:psqdlc.cs9.ln_at_mercury.downsfam.net...
> Dawn M. Wolthuis wrote:
>
> > gains in productivity are due exclusively to the data model. That does
> > seem to me to be one significant component, however, which is why I
> > investigated why the entire profession seems to think that we ought not
> > have embedded lists in our logical data models.
> >
>
> PostgreSQL supports arrays as a type. Does such qualify as an embedded
> list? If not, why not? Is it just about ordering?

I played with PostgreSQL and it does give some of the advantages I was looking for -- in particular, you can query the parent table and access the child data without an explicit join in your query statement (or view) IIRC. After that, then, yes, having the database handle insertions and removals from ordered lists is just another feature that would also be helpful to developers. And then there is the fact that I just really have not found any flavor of SQL to be delightful. --dawn

 --
> Kenneth Downs
> Use first initial plus last name at last name plus literal "fam.net" to
> email me
Received on Sat Oct 23 2004 - 18:10:18 CEST