Postgres Pro
Downloads
Home   >   mailing lists

cursor results count - Mailing list pgsql-sql

From Sergei Barbarash
Subject cursor results count
Date
Msg-id 199808051335.RAA22788@zaraza.dot.ru
Whole thread Raw
Responses Multiple table selection.  (Colin Dick <cdick@mail.ocis.net>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Maarten Boekhold
Date:
Subject: Re: [SQL] How do I get the list of table names in db
Next
From: Colin Dick
Date:
Subject: Multiple table selection.