Re: plpgsql multidimensional array assignment results in array of text instead of subarrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Michael Rasmussen <michaelr(at)porch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Date: 2015-12-28 23:51:50
Message-ID: 1478.1451346710@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Rasmussen 2015-12-28 23:59:55 Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Previous Message David G. Johnston 2015-12-28 23:48:32 Re: plpgsql multidimensional array assignment results in array of text instead of subarrays