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
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
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