[pgrouting-dev] Re: pgrouting-dev Digest, Vol 11, Issue 6

[Jaime Casanova]

On Wed, Apr 13, 2011 at 12:11 PM, cathal coffey <coffey.cathal at gmail.com> wrote:
>
> how do I
> extract the first and last item in a record set?
>

you mean a cursor inside plpgsql?

FETCH FIRST FROM cursor_name INTO some_var;
FETCH LAST FROM cursor name INTO some_var;

now the question is why aren't you using min() and max() in a select?

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL