Postgres Pro
Downloads
Home   >   mailing lists

Re: ARRAY() returning NULL instead of ARRAY[] resp. {} - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Date
Msg-id 1116874691.7306.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: ARRAY() returning NULL instead of ARRAY[] resp. {}  ("Jan B." <jan@monso.de>)
List pgsql-sql
Tree view 
Dnia 23-05-2005, pon o godzinie 18:54 +0000, Jan B. napisał(a):

> Perhaps Arrays always have to contain at least one element? (I don't
> know for sure.)

They can:

template1=# select '{}'::TEXT[];text
------{}
(1 запись)

I don't know, why the ARRAY[] syntax doesn't work for empty arrays.

Markus

--
Markus Bertheau <twanger@bluetwanger.de>

pgsql-sql by date:

Previous
From: "Jan B."
Date:
Subject: Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Next
From: Joe Conway
Date:
Subject: Re: ARRAY() returning NULL instead of ARRAY[] resp. {}