Changing array subscripting to zero-offset

Started by Erin Sheldonalmost 20 years ago2 messagesgeneral
Jump to latest
#1Erin Sheldon
erin.sheldon@gmail.com

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

#2Jorge Godoy
jgodoy@gmail.com
In reply to: Erin Sheldon (#1)
Re: Changing array subscripting to zero-offset

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>