See the LIMIT and OFFSET options in the SELECT command in the manual.
-philip
On Wed, 20 Feb 2002, Stephen Ingram wrote:
>
>
> Hi,
>
> If I am running a query I know could return 1000's of rows;
> is there a PG way to say to just return the first, say, 50 rows?
>
> cheers
>
> steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>