Changing array subscripting to zero-offset
Hello everyone -
Array columns are, by default, 1-offset in their
subscripting. Since I usually am calling postgres
from a language with zero-offset, I would prefer
that postgres conform to that. The online
documentation hints that this may be configurable
but I haven't been able to find how this is done.
Any help is greatly appreciated,
Erin Sheldon
Em Domingo 18 Junho 2006 11:33, Erin Sheldon escreveu:
Hello everyone -
Array columns are, by default, 1-offset in their
subscripting. Since I usually am calling postgres
from a language with zero-offset, I would prefer
that postgres conform to that. The online
documentation hints that this may be configurable
but I haven't been able to find how this is done.Any help is greatly appreciated,
Erin Sheldon
You can always sum 1 to your calculations, so that you have an offset from
your programming language from 0 to 1 for the initial position of the array.
I also use a language where zero is the first position of the array. But if
the behavior is changed, what to do with people that use languages where 1 is
the first position of the array? I believe that we can't please everyone,
so...
--
Jorge Godoy <jgodoy@gmail.com>