Received: from zaraza.dot.ru ([195.151.91.184]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA11464 for ; Wed, 5 Aug 1998 09:35:04 -0400 (EDT) Received: from zaraza (localhost [127.0.0.1]) by zaraza.dot.ru (8.8.8/8.8.8) with ESMTP id RAA22788 for ; Wed, 5 Aug 1998 17:35:59 +0400 (MSD) (envelope-from sgt@zaraza.dot.ru) Message-Id: <199808051335.RAA22788@zaraza.dot.ru> X-Mailer: exmh version 2.0.2 2/24/98 X-face: =^q.\_{=6A5?NeV4x^y8^c9fYLov(VQ=V7Q"p; G|Tx65CH8)=v%1M"/!seMC0oD:)wKSuhC Y&z[m7$XMmM}Q-mHsqALu'FSk7; ytq).]{}|X)Jfe-<7; %xFA4m%OV3,!XF5K!O:B}2Bd0%4y.~~`W !\*/Tis2n"ETu[yflT)l{xWqLf.)7j*0B4/\E9$qp X-url: http://zaraza.rinet.ru/ To: pgsql-sql@postgresql.org Subject: cursor results count Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Wed, 05 Aug 1998 17:35:59 +0400 From: Sergei Barbarash 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