Received: from exchange.bilgi.edu.tr (prol800.ibun.edu.tr [194.27.149.22]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA80000 for ; Tue, 23 May 2000 04:13:14 -0400 (EDT) (envelope-from eroloz@bilgi.edu.tr) Received: from bilgi.edu.tr (AKA610-2 [10.0.10.14]) by exchange.bilgi.edu.tr with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id LNTR37N8; Tue, 23 May 2000 11:08:48 +0300 Message-ID: <392A3CF0.B2F91D76@bilgi.edu.tr> Date: Tue, 23 May 2000 11:10:25 +0300 From: Erol Oz X-Mailer: Mozilla 4.72 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Re: OID References: <200005230812.IAA04248@presence1.observatoiredesmarques.fr> Content-Type: text/plain; charset=iso-8859-9 Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/104 If I understand you correctly, you can use LIMIT 2. christine@observatoiredesmarques.fr wrote: > I have some trouble about the use of OID. > In a EXEC SQL SELECT i want to retrieved only the 2 first rows. Is there in PostgreSQL the possibility to do ...WHERE rownum<3; for example. > thanks, christine.