Re: Proposed TODO: fetch->INT8

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Jeff Davis" <jdavis-pgsql(at)empires(dot)org>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposed TODO: fetch->INT8
Date: 2005-01-24 20:07:20
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A75DD@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeff wrote:
> Is there a practical use for retrieving > 2^31 records at once?
>
> (this is a serious question, I'm not arguing that it should cause a
> syntax error)
>
> Regards,
> Jeff Davis
>
> On Mon, 2005-01-24 at 14:13 -0500, Merlin Moncure wrote:
> > I was browsing the TODO list and I noticed the todo to bump
limit/offset
> > to int8. IMO, the flavors of fetch that take a numeric parameter
need
> > this as well.
> >
> > FWIW, trying to pass integer > 2^31 to fetch gives a syntax error,
which
> > is clearly wrong.

No, but don't forget about relative positioning:
fetch relative c from huge_cursor;

Could make a reasonable case for that.
Merlin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-01-24 21:21:35 Re: Goals for 8.1
Previous Message Jeff Davis 2005-01-24 20:05:20 Re: Proposed TODO: fetch->INT8