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

From Markus Bertheau
Subject Re: Empty array IS NULL?
Date
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?  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
В Пнд, 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:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: Need indexes on inherited tables?
Next
From: Joe Conway
Date:
Subject: Re: Empty array IS NULL?