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

Re: Empty array IS NULL?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Empty array IS NULL?
Date: 2004-06-28 17:56:40
Message-ID: 40E05BD8.6070807@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-sql
Markus Bertheau wrote:
> How do I specify an empty array with the standard syntax?
> 

Actually, up until the 7.4 release, the array literal syntax was the 
*only* syntax (i.e. '{...}'). The newer array constructor expression 
(i.e. ARRAY[...]) does not yet support creating empty arrays -- there 
are some non-trivial technical difficulties to be solved. Unfortunately 
that won't change in the upcoming 7.5 either :( -- perhaps for 7.6.

Joe

In response to

pgsql-sql by date

Next:From: beyaNetDate: 2004-06-28 18:27:13
Subject: unsubscribe
Previous:From: Markus BertheauDate: 2004-06-28 17:06:17
Subject: Re: Empty array IS NULL?

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