Postgres Pro
Downloads
Home   >   mailing lists

array_length of an empty array - Mailing list pgsql-general

From John R Pierce
Subject array_length of an empty array
Date
Msg-id 5014EE38.30202@hogranch.com
Whole thread Raw
Responses Re: array_length of an empty array  (Ryan Kelly <rpkelly22@gmail.com>)
Re: array_length of an empty array  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
hmmm.    array[]::integer[]    is an empty array, {}, eg an array with
zero elements

but array_length(array[]::integer[])   is NULL rather than zero.    this
seems counterintuitive.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Trim not working (PostgreSQL 9.1.2 on Win64)
Next
From: Vincent Veyron
Date:
Subject: Re: BI tools and postgresql