Thread

1. limit select question

   Kevin Heflin <kheflin@shreve.net> — 1999-03-31T04:59:51Z

   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
   --------------------------------------------------------------------
   
   
   

2. Re: [GENERAL] limit select question

   Chris Bitmead <chris.bitmead@bigfoot.com> — 2000-02-28T14:58:33Z

   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.