If I understand you correctly, you can use LIMIT 2.
> 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.
In response to
- OID at 2000-05-23 08:12:41 from christine
pgsql-sql by date
|Next:||From: christine||Date: 2000-05-23 08:12:41|
|Previous:||From: Oliver Elphick||Date: 2000-05-22 20:57:35|
|Subject: Re: re: duplicate key |