Postgres Pro
Downloads
Home   >   mailing lists

Thread: Are NULLs in Arrays compressed?

Are NULLs in Arrays compressed?

From
Simon Riggs
Date:
Are NULLs in Arrays compressed?

Just as NULLs are with normal unary datatypes.

Thanks,

Best Regards, Simon Riggs

Re: Are NULLs in Arrays compressed?

From
mark@mark.mielke.cc
Date:
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
bindthem...
 
                          http://mark.mielke.cc/

Re: Are NULLs in Arrays compressed?

From
Michael Fuhr
Date:
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

Re: Are NULLs in Arrays compressed?

From
mark@mark.mielke.cc
Date:
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
bindthem...
 
                          http://mark.mielke.cc/

Re: Are NULLs in Arrays compressed?

From
Christopher Kings-Lynne
Date:
>>>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