| 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: | A62152A6-C92E-11D8-BA66-0003938366A4@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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
| 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? |