Re: PL/Python adding support for multi-dimensional arrays - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: PL/Python adding support for multi-dimensional arrays
Date
Msg-id 62bcb67d-69db-f485-8726-8d9fa4d8d885@BlueTreble.com
Whole thread Raw
In response to Re: PL/Python adding support for multi-dimensional arrays  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: PL/Python adding support for multi-dimensional arrays
List 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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Hash Indexes
Next
From: Robert Haas
Date:
Subject: store narrow values in hash indexes?