Postgres Pro
Downloads
Home   >   mailing lists

Re: Should array_length() Return NULL - Mailing list pgsql-hackers

From Brendan Jurd
Subject Re: Should array_length() Return NULL
Date
Msg-id CADxJZo30YCHBeoLyzH_BjUrVDr_+gcNx-pBw+R9yqTnJghoCQw@mail.gmail.com
Whole thread Raw
In response to Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 17 March 2013 06:27, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> What I'm concerned about here is whether these expressions shouldn't
> be yielding different data values:
>

>
> Right now, if we did make them produce what they appear to mean, the
> array I/O functions would have a problem with representing the results:
>

> So I think we'd need to fix that before we could go very far in this
> direction.

I agree.  I am starting to work on that very thing.

I noticed that there are a whole bunch of errmsgs in ArrayCount and
ReadArrayStr that just say "malformed array literal" with no detail
message at all.  Not very helpful.  I'm tempted to improve that on my
way past.

Cheers,
BJ

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange Windows problem, lock_timeout test request
Next
From: Tom Lane
Date:
Subject: Re: Should array_length() Return NULL