BUG #14239: Array of array type reporting

Поиск
Список
Период
Сортировка
Искать

BUG #14239: Array of array type reporting

От:
yrashk@gmail.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIzOQpMb2dnZWQgYnk6ICAg
ICAgICAgIFl1cmlpIFJhc2hrb3Zza2lpCkVtYWlsIGFkZHJlc3M6ICAgICAg
eXJhc2hrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9w
ZXJhdGluZyBzeXN0ZW06ICAgTWFjIE9TIFgKRGVzY3JpcHRpb246ICAgICAg
ICAKCkhpLA0KDQpSYW46DQoNCmRiPSMgQ1JFQVRFIFRBQkxFIHNhbF9lbXAg
KA0KZGIoIyAgICAgbmFtZSAgICAgICAgICAgIHRleHQsDQpkYigjICAgICBw
YXlfYnlfcXVhcnRlciAgaW50ZWdlcltdLA0KZGIoIyAgICAgc2NoZWR1bGUg
ICAgICAgIHRleHRbXVtdDQpkYigjICk7DQpDUkVBVEUgVEFCTEUNCmRiPSMg
XGQgc2FsX2VtcDsNCg0KRXhwZWN0ZWQ6DQoNCiAgICAgVGFibGUgImV2ZW50
c291cmNpbmcuc2FsX2VtcCINCiAgICAgQ29sdW1uICAgICB8ICAgVHlwZSAg
ICB8IE1vZGlmaWVycw0KLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSst
LS0tLS0tLS0tLQ0KIG5hbWUgICAgICAgICAgIHwgdGV4dCAgICAgIHwNCiBw
YXlfYnlfcXVhcnRlciB8IGludGVnZXJbXSB8DQogc2NoZWR1bGUgICAgICAg
fCB0ZXh0W11bXSAgICB8DQoNCkdvdDoNCg0KICAgICBUYWJsZSAiZXZlbnRz
b3VyY2luZy5zYWxfZW1wIg0KICAgICBDb2x1bW4gICAgIHwgICBUeXBlICAg
IHwgTW9kaWZpZXJzDQotLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t
LS0tLS0tLS0tDQogbmFtZSAgICAgICAgICAgfCB0ZXh0ICAgICAgfA0KIHBh
eV9ieV9xdWFydGVyIHwgaW50ZWdlcltdIHwNCiBzY2hlZHVsZSAgICAgICB8
IHRleHRbXSAgICB8DQoNCklzIHRoZXJlIGFueSByZWFzb24gd2h5IHNjaGVk
dWxlIHRleHRbXVtdIGlzIHJlcG9ydGVkIGFzIHRleHRbXT8gSSB0aGluayBt
eQpKREJDIGRyaXZlciAocGdqZGJjLW5nKSBwaWNrcyB0aGF0IHVwIGFuZCBm
YWlscyB0byBkbyBwcm9wZXIgY29lcmNpb24KYmVjYXVzZSBpdCB0aGluZ3Mg
aXQncyBzaW1wbHkgYSB0ZXh0W10uCgo=

Re: BUG #14239: Array of array type reporting

От:
Bruce Momjian <bruce@momjian.us>
Дата:
On Sat, Jul  9, 2016 at 03:03:34PM -0400, Peter Eisentraut wrote:
> On 7/9/16 12:57 PM, yrashk@gmail.com wrote:
> >Is there any reason why schedule text[][] is reported as text[]?
> 
> There is no such thing as text[][].  I'm not sure why it's accepted (perhaps
> backward compatibility), but PostgreSQL only supports one level of
> array-ness, which can, however, be multidimensional.
> 
> So this is nothing to worry about.

Yeah, arrays basically don't store any supplied dimmensions:

	test=> CREATE TABLE test(x TEXT[3]);
	CREATE TABLE

	test=> \d test
	     Table "public.test"
	 Column |  Type  | Modifiers
	--------+--------+-----------
	 x      | text[] |

	              ^^

-- 
  Bruce Momjian          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +

Re: BUG #14239: Array of array type reporting

От:
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Дата:
On 7/9/16 12:57 PM, yrashk@gmail.com wrote:
> Is there any reason why schedule text[][] is reported as text[]?

There is no such thing as text[][].  I'm not sure why it's accepted 
(perhaps backward compatibility), but PostgreSQL only supports one level 
of array-ness, which can, however, be multidimensional.

So this is nothing to worry about.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
FAQ