Postgres Pro
Downloads
Home   >   mailing lists

Thread: OID

OID

From
christine@observatoiredesmarques.fr
Date:
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.

Re: OID

From
Erol Oz
Date:
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.