Re: count of query results in for loop

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: count of query results in for loop
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C203937E79@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на count of query results in for loop  (Sim Zacks <sim@compulab.co.il>)
Список pgsql-general
Sim Zacks wrote:
> Is there any way to (without a separate count query first) to know the
> number of rows returned in a:
>
>     for x in select ... Loop
>
>     ...
>
>     End Loop
>
> structure?

No. Not before you exit the loop.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления: