Home > mailing lists

Re: Empty array IS NULL? - Mailing list pgsql-sql

From	Markus Bertheau
Subject	Re: Empty array IS NULL?
Date	June 28, 2004 17:10:15
Msg-id	1088442376.2715.1.camel@teetnang Whole thread Raw
In response to	Re: Empty array IS NULL? (Joe Conway <mail@joeconway.com>)
Responses	Re: Empty array IS NULL?
List	pgsql-sql

Tree view

В Пнд, 28.06.2004, в 18:26, Joe Conway пишет:
> Markus Bertheau wrote:
> > is the empty array representable in PostgreSQL, and is it
> > distinguishable from NULL?
>
> Yes, and yes.
>
> Since NULL array elements are not currently supported, attempting to
> construct an array with a NULL element results in NULL, not an empty array.

Thanks.

How do I specify an empty array with the standard syntax?

--
Markus Bertheau <twanger@bluetwanger.de>

pgsql-sql by date:

From: Franco Bruno Borghesi
Date: 28 June 2004, 16:31:14
Subject: Re: Need indexes on inherited tables?

From: Joe Conway
Date: 28 June 2004, 17:56:58
Subject: Re: Empty array IS NULL?

Re: Empty array IS NULL? - Mailing list pgsql-sql

Previous

Next