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

From Harald Fuchs
Subject Re: Supporting NULL elements in arrays
Date
Msg-id 871x1r1717.fsf@srv.protecting.net
Whole thread Raw
In response to Re: Supporting NULL elements in arrays  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Responses Re: Supporting NULL elements in arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
In article <4370B990.7090100@dunslane.net>,
Andrew Dunstan <andrew@dunslane.net> writes:

> Tom Lane wrote:

>> "Pavel Stehule" <pavel.stehule@hotmail.com> writes:
>> 
>>> it's great news. My personal opinion about formating NULL values
>>> '{a, NULL, b}' -- longer, clean NULL is NULL
>>> 
>> 
>> Unfortunately, that already has a meaning, and it's not that.
>> 
>> 
>> 

> What a pity. I don't see any alternative to the empty element proposal
> -
> it's worth the possible breakage.

How about '{a, \N, b}'?



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: plperl error when making 8.2dev CVS
Next
From: Tom Lane
Date:
Subject: Re: Supporting NULL elements in arrays