Re: MOVE cursor in plpgsql?

Поиск
Список
Период
Сортировка
От Webb Sprague
Тема Re: MOVE cursor in plpgsql?
Дата
Msg-id b11ea23c0702110902i23e1e752ofc8d2839a4c963ca@mail.gmail.com
обсуждение исходный текст
Ответ на Re: MOVE cursor in plpgsql?  (Tomas Vondra <tv@fuzzy.cz>)
Список 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 по дате отправления:

Предыдущее
От: "dfx"
Дата:
Сообщение: How to preserve characters with accent?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: How to preserve characters with accent?