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.