Re: MOVE cursor in plpgsql? - Mailing list pgsql-general

From Webb Sprague
Subject Re: MOVE cursor in plpgsql?
Date
Msg-id b11ea23c0702110902i23e1e752ofc8d2839a4c963ca@mail.gmail.com
Whole thread Raw
In response to Re: MOVE cursor in plpgsql?  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-general
> > Is there a way to move a cursor in plpgsql in the same way as in
> > regular sql?  ...
>
> Wouldn't it be easier to list the parts in a random order (simply ORDER
> BY RANDOM()) and then use modulo by number of actors (but there's no
> ROWNUM so a loop is needed anyway). Something like...

I think you are right Thomas about the modulo, and that might be even
better stylistically (more obvious to the reader) -- thanks!

I still wonder if MOVing cursor in plpgsql is impossible, possible, or
available soon?

Thanks again,
W

pgsql-general by date:

Previous
From: "dfx"
Date:
Subject: How to preserve characters with accent?
Next
From: Peter Eisentraut
Date:
Subject: Re: How to preserve characters with accent?