Re: How may I keep prepended array items positive?

I want to use it like this...

UPDATE SET _array = {1,2,3} || _array;

Which if _array had {1} in it, I'd get something like
[-2:1]{1,1,2,3} as the range... I only want it to push
the existing values to the right so I'd have
[1:4]{1,1,2,3}

I don't have a pgsql on this box to show output..


--- Michael Fuhr <mike@fuhr.org> wrote:

> On Mon, Oct 31, 2005 at 04:37:39PM -0800, Matthew
> Peter wrote:
> > I would need to prepend a couple array items BUT I
> > NEED them to be positive [1:13] instead of [-4:9]
> for
> > instance.
> >
> > How may I keep prepended array items positive?
>
> You could use array-to-array concatenation instead
> of prepending
> (aka element-to-array concatenation):
>
> test=> SELECT 99 || ARRAY[1, 2, 3];  -- unwanted
> results
>      ?column?
> ------------------
>  [0:3]={99,1,2,3}
> (1 row)
>
> test=> SELECT ARRAY[99] || ARRAY[1, 2, 3];  --
> desired results
>   ?column?
> ------------
>  {99,1,2,3}
> (1 row)
>
> --
> Michael Fuhr
>




__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com