Re: LIMIT question - Mailing list pgsql-sql

From Richard Broersma
Subject Re: LIMIT question
Date
Msg-id 396486430808191408q65addcb3pfd4bd663963c5377@mail.gmail.com
Whole thread Raw
In response to LIMIT question  ("EXT-Rothermel, Peter M" <Peter.M.Rothermel@boeing.com>)
Responses Re: LIMIT question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Tue, Aug 19, 2008 at 1:58 PM, EXT-Rothermel, Peter M
<Peter.M.Rothermel@boeing.com> wrote:
> Now I can give some feedback like your search matches 200,000 but was
> limited to 1000 items.
> Is there a better way to accomplish this goal?

Here is a nice discussion on the alternatives open to you:
http://www.commandprompt.com/blogs/joshua_drake/2007/08/how_many_rows_do_i_have_anyway/


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

Previous
From: "EXT-Rothermel, Peter M"
Date:
Subject: LIMIT question
Next
From: "Edward W. Rouse"
Date:
Subject: Re: Join question