From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
---|---|
To: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Dave Cramer <pg(at)fastcrypt(dot)com>, Alexey Grishchenko <programmerag(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PL/Python adding support for multi-dimensional arrays |
Date: | 2016-09-23 19:27:27 |
Message-ID: | 62bcb67d-69db-f485-8726-8d9fa4d8d885@BlueTreble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 9/23/16 2:42 AM, Heikki Linnakangas wrote:
> How do we handle single-dimensional arrays of composite types at the
> moment? At a quick glance, it seems that the composite types are just
> treated like strings, when they're in an array. That's probably OK, but
> it means that there's nothing special about composite types in
> multi-dimensional arrays. In any case, we should mention that in the docs.
That is how they're handled, but I'd really like to change that. I've
held off because I don't know how to handle the backwards
incompatibility that would introduce. (I've been wondering if we might
add a facility to allow specifying default TRANSFORMs that should be
used for specific data types in specific languages.)
The converse case (a composite with arrays) suffers the same problem
(array is just treated as a string).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2016-09-23 19:32:49 | store narrow values in hash indexes? |
Previous Message | Robert Haas | 2016-09-23 19:19:14 | Re: Hash Indexes |