Обсуждение: OID

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.

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.