count of query results in for loop

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: count of query results in for loop
Date: 2009-07-28 09:03:36
Message-ID: 4A6EBEE8.9030903@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-07-28 09:07:06 Re: For production: 8.4 or 8.3?
Previous Message Magnus Hagander 2009-07-28 08:57:29 Re: For production: 8.4 or 8.3?