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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq