Re: Some array semantics issues - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Some array semantics issues
Date
Msg-id 437EB987.9060708@joeconway.com
Whole thread Raw
In response to Re: Some array semantics issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Given the just-committed changes to avoid having array_push/array_cat
> generate non-spec lower bounds unnecessarily, do you still think it's
> important to have a variant of array comparison that ignores lower
> bounds?
> 
> ISTM that ignoring lower bounds is definitely something that violates
> the principle of least surprise.  There was an ease-of-use argument
> for it before, but now that we changed the other thing I think we don't
> need such a kluge.

I agree. At this point, having an array with other than 1 as a lower 
bound takes a very conscious decision. I'd think that if you cared that 
much about the lower bound, you'd not want to ignore it when it comes to 
comparison.

Joe



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: order by, for custom types
Next
From: Heikki Linnakangas
Date:
Subject: Materialized views (Was Re: Improving count(*))