Re: [GENERAL] Postgres doesn't seem to enforce array dimensions

2010-04-08 Thread Simon Riggs
On Thu, 2010-04-08 at 11:02 -0700, Jeff Davis wrote: > 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

Re: [GENERAL] Postgres doesn't seem to enforce array dimensions

2010-04-08 Thread Jeff Davis
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

[GENERAL] Postgres doesn't seem to enforce array dimensions

2010-04-08 Thread Joseph S
What's up with Postgres and array dimensions? The table definition doesn't even store how many dimensions the array should be. [local]:playpen=> create table arrtest( playpen(>id SERIAL PRIMARY KEY, playpen(> arrone int[], playpen(> arrtwo int[][] playpen(> ); NOTICE: CREATE TABLE will