Thread: BUG #14239: Array of array type reporting
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIzOQpMb2dnZWQgYnk6ICAg ICAgICAgIFl1cmlpIFJhc2hrb3Zza2lpCkVtYWlsIGFkZHJlc3M6ICAgICAg eXJhc2hrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9w ZXJhdGluZyBzeXN0ZW06ICAgTWFjIE9TIFgKRGVzY3JpcHRpb246ICAgICAg ICAKCkhpLA0KDQpSYW46DQoNCmRiPSMgQ1JFQVRFIFRBQkxFIHNhbF9lbXAg KA0KZGIoIyAgICAgbmFtZSAgICAgICAgICAgIHRleHQsDQpkYigjICAgICBw YXlfYnlfcXVhcnRlciAgaW50ZWdlcltdLA0KZGIoIyAgICAgc2NoZWR1bGUg ICAgICAgIHRleHRbXVtdDQpkYigjICk7DQpDUkVBVEUgVEFCTEUNCmRiPSMg XGQgc2FsX2VtcDsNCg0KRXhwZWN0ZWQ6DQoNCiAgICAgVGFibGUgImV2ZW50 c291cmNpbmcuc2FsX2VtcCINCiAgICAgQ29sdW1uICAgICB8ICAgVHlwZSAg ICB8IE1vZGlmaWVycw0KLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSst LS0tLS0tLS0tLQ0KIG5hbWUgICAgICAgICAgIHwgdGV4dCAgICAgIHwNCiBw YXlfYnlfcXVhcnRlciB8IGludGVnZXJbXSB8DQogc2NoZWR1bGUgICAgICAg fCB0ZXh0W11bXSAgICB8DQoNCkdvdDoNCg0KICAgICBUYWJsZSAiZXZlbnRz b3VyY2luZy5zYWxfZW1wIg0KICAgICBDb2x1bW4gICAgIHwgICBUeXBlICAg IHwgTW9kaWZpZXJzDQotLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tDQogbmFtZSAgICAgICAgICAgfCB0ZXh0ICAgICAgfA0KIHBh eV9ieV9xdWFydGVyIHwgaW50ZWdlcltdIHwNCiBzY2hlZHVsZSAgICAgICB8 IHRleHRbXSAgICB8DQoNCklzIHRoZXJlIGFueSByZWFzb24gd2h5IHNjaGVk dWxlIHRleHRbXVtdIGlzIHJlcG9ydGVkIGFzIHRleHRbXT8gSSB0aGluayBt eQpKREJDIGRyaXZlciAocGdqZGJjLW5nKSBwaWNrcyB0aGF0IHVwIGFuZCBm YWlscyB0byBkbyBwcm9wZXIgY29lcmNpb24KYmVjYXVzZSBpdCB0aGluZ3Mg aXQncyBzaW1wbHkgYSB0ZXh0W10uCgo=
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
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 <bruce@momjian.us> 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 +