From: | "Rudy Gireyev" <rgireyev(at)cnmnetwork(dot)com> |
---|---|
To: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com>, kheflin(at)shreve(dot)net |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | RE: [GENERAL] limit select question |
Date: | 1999-03-31 23:16:53 |
Message-ID: | 199903312316.SAA46922@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
May be I'm missing something, but why not use the cursor?
Do the select once and then fetch as many rows as you need.
Rudy
On 31 Mar 99, at 1:20, Michael Davis wrote:
> Select * From table_name limit 1;
>
> -----Original Message-----
> From: Kevin Heflin [SMTP:kheflin(at)shreve(dot)net]
> Sent: Tuesday, March 30, 1999 10:00 PM
> To: PGSQL-General (E-mail)
> Subject: [GENERAL] 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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
> --------------------------------------------------------------------
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1999-04-01 01:14:58 | Re: [GENERAL] Performance |
Previous Message | Jackson, DeJuan | 1999-03-31 17:03:03 | RE: [GENERAL] Unix crypt() for PostgreSQL |