Re: MOVE cursor in plpgsql?

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MOVE cursor in plpgsql?
Date: 2007-02-11 17:02:46
Message-ID: b11ea23c0702110902i23e1e752ofc8d2839a4c963ca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-02-11 17:27:43 Re: How to preserve characters with accent?
Previous Message dfx 2007-02-11 16:08:13 How to preserve characters with accent?