Re: PL/Python adding support for multi-dimensional arrays

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

In response to

Responses

Browse pgsql-hackers by date

  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