cursor results count

From: Sergei Barbarash <sgt(at)israel(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: cursor results count
Date: 1998-08-05 13:35:59
Message-ID: 199808051335.RAA22788@zaraza.dot.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I need to retrieve one random tuple from a big set of tuples returned by a
certain query. So my question is:

How can I find out the number of tuples returned by cursor, without actually
FETCHing ALL? (So I can MOVE then to that location and just FETCH 1).

Thanks,

-- Sergei

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Colin Dick 1998-08-05 15:37:00 Multiple table selection.
Previous Message Maarten Boekhold 1998-08-05 13:31:27 Re: [SQL] How do I get the list of table names in db