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

From Joe Conway
Subject Re: Empty array IS NULL?
Date
Msg-id 40E05BD8.6070807@joeconway.com
Whole thread Raw
In response to Re: Empty array IS NULL?  (Markus Bertheau <twanger@bluetwanger.de>)
List 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


pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: Empty array IS NULL?
Next
From: Joe Conway
Date:
Subject: Re: Empty array IS NULL?