Re: Some questions about the array. - Mailing list pgsql-hackers

From YUriy Zhuravlev
Subject Re: Some questions about the array.
Date
Msg-id 2140159.HH0D5mDkSl@dinodell
Whole thread Raw
In response to Re: Some questions about the array.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Some questions about the array.  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Sunday 08 November 2015 16:49:20 you wrote:
> I'm not necessarily objecting to that, but it's not impossible that it
> could break something for some existing user.  We can decide not to
> care about that, though.

We had an idea. You can use ~ to convert the index to the array which always 
starts with 0. Then we can use negative indexes, and you can always find the 
beginning of the array.
Example:
we have array [-3:3]={1,2,3,4,5,6,7}
array[~0] == 1
array[~-1] == 7
array[~2:~-2] == {3,4,5,6}

What do you think?
-- 
YUriy Zhuravlev
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company



pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Transactions involving multiple postgres foreign servers
Next
From: Pavel Stehule
Date:
Subject: Re: Some questions about the array.