X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 49C8F52874 for ; Mon, 23 May 2005 15:58:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76272-06 for ; Mon, 23 May 2005 18:58:16 +0000 (GMT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id D1DD952864 for ; Mon, 23 May 2005 15:58:14 -0300 (ADT) Received: from tschibtschibojtschitsch (dsl-082-082-197-102.arcor-ip.net [82.82.197.102]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id j4NIwCe11599; Mon, 23 May 2005 20:58:12 +0200 Subject: Re: ARRAY() returning NULL instead of ARRAY[] resp. {} From: Markus Bertheau To: "Jan B." Cc: pgsql-sql@postgresql.org In-Reply-To: <429226CF.4090207@monso.de> References: <1116873219.7306.0.camel@localhost.localdomain> <429226CF.4090207@monso.de> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-BRCIdvLv3pX8nSH9nAOP" Date: Mon, 23 May 2005 20:58:11 +0200 Message-Id: <1116874691.7306.3.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.14 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/191 X-Sequence-Number: 21504 --=-BRCIdvLv3pX8nSH9nAOP Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Dnia 23-05-2005, pon o godzinie 18:54 +0000, Jan B. napisa=C5=82(a): > Perhaps Arrays always have to contain at least one element? (I don't=20 > know for sure.) They can: template1=3D# select '{}'::TEXT[]; text ------ {} (1 =D0=B7=D0=B0=D0=BF=D0=B8=D1=81=D1=8C) I don't know, why the ARRAY[] syntax doesn't work for empty arrays. Markus --=20 Markus Bertheau --=-BRCIdvLv3pX8nSH9nAOP Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBCkifD2RUnMPztcykRArOYAJ9WQD4LT7jIi2l36TJ8pJsVS//niACeIK5z S4bwbe7yktCUCWpjho+m5FY= =wByB -----END PGP SIGNATURE----- --=-BRCIdvLv3pX8nSH9nAOP--