Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql multidimensional array assignment results in array of text instead of subarrays - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Date
Msg-id 1478.1451346710@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql multidimensional array assignment results in array of text instead of subarrays  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: plpgsql multidimensional array assignment results in array of text instead of subarrays  (Michael Rasmussen <michaelr@porch.com>)
List pgsql-general
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> ​or a more semantically meaning one...the use of the inner array is
> arguably a hack here meant to avoid the overhead and new type creation by
> assigning meaning to array slots.

Yeah, good point: it looks like Mike does not consider the columns of
the array to be interchangeable at all, so really he would be better
off modeling the data as you suggest.

            regards, tom lane

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Next
From: Michael Rasmussen
Date:
Subject: Re: plpgsql multidimensional array assignment results in array of text instead of subarrays