Re: plpgsql array looping - Mailing list pgsql-sql

From Richard Albright
Subject Re: plpgsql array looping
Date
Msg-id 1177509269.9556.2.camel@MSI1036
Whole thread Raw
In response to Re: plpgsql array looping  (John DeSoi <desoi@pgedit.com>)
List pgsql-sql
yeah i noticed that this morning, it used to be a while loop, for some
reason (probably parser related) it keeps giving me an error on the exit
when statement in the loop.

On Wed, 2007-04-25 at 09:38 -0400, John DeSoi wrote:
> One problem (unless you intend to only look at every other element)  
> is that you are incrementing idxptr explicitly in your loop. The FOR  
> loop does that for you. This is the reason your output shows only  
> even values.
> 
> John
> 
> 
> On Apr 24, 2007, at 4:42 PM, Richard Albright wrote:
> 
> >     for idxptr in 1 .. array_upper(p_idxarray, 1)
> >     loop
> >         exit when p_idxarray[idxptr] >= p_idx;
> >         idxptr := idxptr +1;
> >         raise notice 'idx ptr: %', idxptr;
> >     end loop;
> 
> 
> 
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
> 
>                 http://www.postgresql.org/about/donate
-- 
Rick Albright
Senior Quantitative Analyst
Indie Research, LLC
254 Witherspoon Street
Princeton, NJ 08542
(609)497-1030
ralbright@insiderscore.com



pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: plpgsql array looping
Next
From: Michael Fuhr
Date:
Subject: Re: Which function transform x,y to latitude/longitude?