Re: Arrays and "goodness" in RDBMSs (was Re: join of array)
От | elein |
---|---|
Тема | Re: Arrays and "goodness" in RDBMSs (was Re: join of array) |
Дата | |
Msg-id | 20030815113213.H22348@cookie обсуждение исходный текст |
Ответ на | Arrays and "goodness" in RDBMSs (was Re: join of array) (Ron Johnson <ron.l.johnson@cox.net>) |
Ответы |
Re: Arrays and "goodness" in RDBMSs (was Re: join of
|
Список | pgsql-general |
PostgreSQL is an ORDBMS, not just an RDBMS. A column holds a type of value. Any kind. The structure and operands define the type. The data defines the value. This holds true for simple types like an integer or complex types like an array. The database data is relatively "type blind" in an ORDBMS. It uses the standard overloaded operands to determine the type of function to perform for all of the usual RDBMS utilities. Constraints, triggers, sorting, etc. all apply. That's what the ORDBMS stuff can give you. Arrays are a natural extension. Arrays don't necessarily imply denormalization. It depends on how you use them. The same rule applies for integers. elein On Fri, Aug 15, 2003 at 01:13:52PM -0500, Ron Johnson wrote: > > Why are arrays even mentioned in the the same breath wrt relations > DBMSs? Aren't they an anathema to all we know and love? > > -- > +---------------------------------------------------------------+ > | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | > | Jefferson, LA USA | > | | > | "Man, I'm pretty. Hoo Hah!" | > | Johnny Bravo | > +---------------------------------------------------------------+ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
В списке pgsql-general по дате отправления: