Skip site navigation (1) Skip section navigation (2)

Re: array dimensions, pg_catalog.pg_attribute and the \d command

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: array dimensions, pg_catalog.pg_attribute and the \d command
Date: 2012-02-06 08:42:43
Message-ID: 201202061042.43350.achill@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Παρ 03 Φεβ 2012 22:21:49 Dmitriy Igrishin wrote:
> Hey Achilleas,
> 
> 2012/2/3 Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
> 
> > Hello,
> > just a question regarding multidimensional arrays.
> > When i create an array, its number of dimensions is recorded in
> > pg_catalog.pg_attribute (attndims), but they are not enforced upon
> > insertion,
> > nor is this presented by \d command. (i didn't see any attndims column
> > showing
> > up in the logs)
> > 
> > Any reasons why this is so?
> 
> According to the documentation
> "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."
> See
> http://www.postgresql.org/docs/9.1/static/arrays.html#ARRAYS-DECLARATION

Thanx Dmitry.

In response to

pgsql-sql by date

Next:From: Jasen BettsDate: 2012-02-06 11:05:15
Subject: Re: type cast about int to bit
Previous:From: zoulx1982Date: 2012-02-06 06:11:12
Subject: type cast about int to bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group