Re: Supporting NULL elements in arrays - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Supporting NULL elements in arrays
Date
Msg-id BAY20-F23F067C141B294DC25D0B1F9640@phx.gbl
Whole thread Raw
In response to Supporting NULL elements in arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Supporting NULL elements in arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello,

it's great news. My personal opinion about formating NULL values  '{a,"",b}  -- wrong, "" means empty string, isn't
null '{a,,b} '   -- ok, maybe not unique,  '{a, NULL, b}' -- longer, clean NULL is NULL  '{a, "NULL", b}' -- "NULL" is
notnull varchar 'NULL'
 

Flags for array? Maybe bit isHash? So, hash array can be in line

array->null array->hash array

or flag for nor regular array (sparse array), not type unique arrays (array 
can contains different types)

Regards
Pavel Stehule

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. 
http://www.msn.cz/



pgsql-hackers by date:

Previous
From: Lars Kanis
Date:
Subject: Re: Problems with index-scan on regexp in 8.1
Next
From: Richard Huxton
Date:
Subject: Re: Copy From CSV feature request?