Postgres Pro
Downloads
Home   >   mailing lists

Re: count of query results in for loop - Mailing list pgsql-general

From Albe Laurenz
Subject Re: count of query results in for loop
Date
Msg-id D960CB61B694CF459DCFB4B0128514C203937E79@exadv11.host.magwien.gv.at
Whole thread Raw
In response to count of query results in for loop  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: C Function Question
Next
From: Bill Moran
Date:
Subject: Re: Video available for PGDay SJC '09