On Thu, 2010-04-08 at 13:30 -0400, Joseph S wrote: > What's up with Postgres and array dimensions? The table definition > doesn't even store how many dimensions the array should be. >
That's a little strange, but it is documented behavior: >From http://www.postgresql.org/docs/8.4/static/arrays.html : "However, the current implementation ignores any supplied array size limits, i.e., the behavior is the same as for arrays of unspecified length. The current implementation does not enforce the declared number of dimensions either. Arrays of a particular element type are all considered to be of the same type, regardless of size or number of dimensions. So, declaring the array size or number of dimensions in CREATE TABLE is simply documentation; it does not affect run-time behavior." Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
