Thread: limit select question

limit select question

From
Kevin Heflin
Date:
I've been asked if there is a way to LIMIT the number of results displayed
when doing a SELECT with postgresql, by a former user of mysql. Wasn't
sure if there is an easy way to do this or not. I've don't it before, but
in a very round about way... any suggestions.

> with mySQL and SELECT queries
> you can LIMIT the number of results displayed to the screen. I can't
> seem to find any such switch in the SELECT commands in postgres.


Kevin


--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------


Re: [GENERAL] limit select question

From
Chris Bitmead
Date:
Kevin Heflin wrote:
>
> I've been asked if there is a way to LIMIT the number of results displayed
> when doing a SELECT with postgresql, by a former user of mysql. Wasn't
> sure if there is an easy way to do this or not. I've don't it before, but
> in a very round about way... any suggestions.

I'm not an expert, but why not just read X results from the portal, then
close the portal? That is what I'm doing.