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

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Re: array dimensions, pg_catalog.pg_attribute and the \d command
Дата
Msg-id CAAfz9KOMnOgT8ZTWcKxmJ+-97VcCb+VdgGOVUR6s9pmDDXo2Lw@mail.gmail.com
обсуждение исходный текст
Ответ на array dimensions, pg_catalog.pg_attribute and the \d command  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: array dimensions, pg_catalog.pg_attribute and the \d command  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-sql
Дерево обсуждения
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

--
// Dmitriy.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: array dimensions, pg_catalog.pg_attribute and the \d command
Следующее
От: Andreas
Дата:
Сообщение: Is there a way to remove every character but numbers?