Skip site navigation (1) Skip section navigation (2)

Re: Empty array IS NULL?

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Empty array IS NULL?
Date: 2004-06-28 17:06:17
Message-ID: 1088442376.2715.1.camel@teetnang (view raw or flat)
Thread:
Lists: 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(at)bluetwanger(dot)de>


In response to

Responses

pgsql-sql by date

Next:From: Joe ConwayDate: 2004-06-28 17:56:40
Subject: Re: Empty array IS NULL?
Previous:From: Franco Bruno BorghesiDate: 2004-06-28 16:30:16
Subject: Re: Need indexes on inherited tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group