Are NULLs in Arrays compressed?

On Mon, Nov 21, 2005 at 08:51:32PM +0000, Simon Riggs wrote:

Are NULLs in Arrays compressed?
Just as NULLs are with normal unary datatypes.

I thought NULLs don't work in arrays yet? :-)

mark

--
mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada

One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...

http://mark.mielke.cc/

On Mon, Nov 21, 2005 at 04:46:40PM -0500, mark@mark.mielke.cc wrote:

On Mon, Nov 21, 2005 at 08:51:32PM +0000, Simon Riggs wrote:

Are NULLs in Arrays compressed?
Just as NULLs are with normal unary datatypes.

I thought NULLs don't work in arrays yet? :-)

http://archives.postgresql.org/pgsql-committers/2005-11/msg00385.php
http://developer.postgresql.org/docs/postgres/arrays.html

--
Michael Fuhr

On Mon, Nov 21, 2005 at 08:12:10PM -0700, Michael Fuhr wrote:

On Mon, Nov 21, 2005 at 04:46:40PM -0500, mark@mark.mielke.cc wrote:

On Mon, Nov 21, 2005 at 08:51:32PM +0000, Simon Riggs wrote:

Are NULLs in Arrays compressed?
Just as NULLs are with normal unary datatypes.

I thought NULLs don't work in arrays yet? :-)

http://archives.postgresql.org/pgsql-committers/2005-11/msg00385.php
http://developer.postgresql.org/docs/postgres/arrays.html

Ahh... Thanks.

And you did it right. Good. :-)

mark

P.S. I followed the discussions regarding what to do, but missed the
conclusion and the resulting patch.

--
mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada

One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...

http://mark.mielke.cc/

I thought NULLs don't work in arrays yet? :-)

http://archives.postgresql.org/pgsql-committers/2005-11/msg00385.php
http://developer.postgresql.org/docs/postgres/arrays.html

Someone's checked that this NULLs in arrays stuff doesn't affect indexes
over array elements, etc.? Or indexes that don't store nulls, etc.

Chris