Re: Changing array subscripting to zero-offset

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing array subscripting to zero-offset
Date: 2006-06-22 12:29:36
Message-ID: 200606220929.36791.jgodoy@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2006-06-22 12:36:05 Re: Form builder?
Previous Message Douglas McNaught 2006-06-22 12:25:03 Re: Interface Guidance and Opinions Needed