Обсуждение: limit select question
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 --------------------------------------------------------------------
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.