| 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: | Whole Thread | Raw Message | 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>
| 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 |