Re: Supporting NULL elements in arrays

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Supporting NULL elements in arrays
Date: 2005-11-08 08:27:03
Message-ID: BAY20-F23F067C141B294DC25D0B1F9640@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 not null 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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2005-11-08 08:42:39 Re: Copy From CSV feature request?
Previous Message Lars Kanis 2005-11-08 08:23:32 Re: Problems with index-scan on regexp in 8.1