From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-sql@postgresql.org
Subject: Re: array dimensions, pg_catalog.pg_attribute and the \d command
Date: Mon, 6 Feb 2012 10:42:43 +0200
Message-ID: <201202061042.43350.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <CAAfz9KOMnOgT8ZTWcKxmJ+-97VcCb+VdgGOVUR6s9pmDDXo2Lw@mail.gmail.com>
References: <201202031741.59171.achill@matrix.gatewaynet.com>
<CAAfz9KOMnOgT8ZTWcKxmJ+-97VcCb+VdgGOVUR6s9pmDDXo2Lw@mail.gmail.com>
On Παρ 03 Φεβ 2012 22:21:49 Dmitriy Igrishin wrote:
> Hey Achilleas,
>
> 2012/2/3 Achilleas Mantzios <achill@matrix.gatewaynet.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: array dimensions, pg_catalog.pg_attribute and the \d command
In-Reply-To: <201202061042.43350.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox