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

From Joe Conway
Subject Re: Empty array IS NULL?
Date
Msg-id A62152A6-C92E-11D8-BA66-0003938366A4@joeconway.com
Whole thread Raw
In response to 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Empty array IS NULL?
Next
From: beyaNet
Date:
Subject: unsubscribe