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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

  From Date Subject
Next Message beyaNet 2004-06-28 18:27:13 unsubscribe
Previous Message Markus Bertheau 2004-06-28 17:06:17 Re: Empty array IS NULL?