2015-03-20 17:49 GMT+01:00 Dean Rasheed <dean.a.rash...@gmail.com>: > On 18 March 2015 at 19:03, Alvaro Herrera <alvhe...@2ndquadrant.com> > wrote: > > Pushed after adding error checks there and fixing the docs to match. > > Please verify. > > > > There's an issue when the array's lower bound isn't 1: > > select array_offset('[2:4]={1,2,3}'::int[], 1); > array_offset > -------------- > 1 > (1 row) > > whereas I would expect this to return 2. Similarly for > array_offsets(), so the offsets can be used as indexes into the > original array. >
I am thinking, so it is ok - it returns a offset, not position. Regards Pavel > > Regards, > Dean >