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, whole thread or download thread mbox)
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.


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

Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to


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-2017 The PostgreSQL Global Development Group