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:[EMAIL PROTECTED]]
> Se
:[EMAIL PROTECTED]]
Sent: Wednesday, March 31, 1999 12:30 AM
To: Michael Davis
Cc: PGSQL-General (E-mail)
Subject:RE: [GENERAL] limit select question
On Wed, 31 Mar 1999, Michael Davis wrote:
> Good point. I am running 6.5. So
On Wed, 31 Mar 1999, Michael Davis wrote:
> Good point. I am running 6.5. So it has been fixed. I am not sure what
> patch is needed to make this work on 6.4.2.
Is version 6.5 to be had some where, or is it only in beta?
I sure could use that feature on a project I'm working on right now...
Cc: PGSQL-General (E-mail)
Subject:RE: [GENERAL] limit select question
On Wed, 31 Mar 1999, Michael Davis wrote:
> Select * From table_name limit 1;
I'm running postgres6.4.2, and this query fails with:
ERROR: parser: parse error at or
On Wed, 31 Mar 1999, Michael Davis wrote:
> Select * From table_name limit 1;
I'm running postgres6.4.2, and this query fails with:
ERROR: parser: parse error at or near "1"
I was told I could gain this feature by adding the 6.4.2 feature patch.
But when I tried installing the patch, anything
Select * From table_name limit 1;
-Original Message-
From: Kevin Heflin [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 30, 1999 10:00 PM
To: PGSQL-General (E-mail)
Subject:[GENERAL] limit select question
I've been asked if t
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.
