Re: Arrays and "goodness" in RDBMSs (was Re: join of array)

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(dot)l(dot)johnson(at)cox(dot)net |
> | Jefferson, LA USA |
> | |
> | "Man, I'm pretty. Hoo Hah!" |
> | Johnny Bravo |
> +---------------------------------------------------------------+
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>