Skip site navigation (1) Skip section navigation (2)

Re: array_lower /array_prepend doubt

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>,pgsql-sql(at)postgresql(dot)org
Subject: Re: array_lower /array_prepend doubt
Date: 2004-01-21 18:47:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Tom Lane wrote:
> Of course; I suppose this bug goes back to Berkeley days.  We just
> hadn't recognized it before (or at least I hadn't).

Neither had I. But the changes in 7.4 probably make it more likely 
people will bump into this as a problem.

Without looking to confirm, I believe SQL99 defines an array as always 
having a lower bound of 1, making our behavior an extension to the 
standard. We may need another extension to the array literal syntax in 
order to deal with this. I'll report back after I've had some time to 
study it.


In response to


pgsql-sql by date

Next:From: Tom LaneDate: 2004-01-21 19:15:51
Subject: Re: array_lower /array_prepend doubt
Previous:From: Tom LaneDate: 2004-01-21 18:41:00
Subject: Re: array_lower /array_prepend doubt

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group