Re: Arrays: missing/skipped elements - Mailing list pgsql-general

From Tom Lane
Subject Re: Arrays: missing/skipped elements
Date
Msg-id 21101.1038900056@sss.pgh.pa.us
Whole thread Raw
In response to Arrays: missing/skipped elements  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Steve Crawford <scrawford@pinpointresearch.com> writes:
> I know from the docs that array elements can't have a null value. It appears,
> therefore, that Postgres fills in missing elements with zero-length strings,
> the int or numeric value zero, etc. appropriate to the data type. Is my
> interpretation correct and is this documented/likely to continue in future
> versions?

One would hope that we'll support null elements in arrays, sooner or
later.  I'm not really sure what the textual representation for that
should be, however.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Segmentation fault while COPY in 7.3
Next
From: Neil Conway
Date:
Subject: Re: 7.3 on OS X HOWTO