Received: from mail.STRATEGICNETWORK.ORG ([216.1.60.176]) by hub.org (8.9.3/8.9.1) with ESMTP id KAA66272 for ; Thu, 22 Apr 1999 10:34:18 -0400 (EDT) (envelope-from justinlong@strategicnetwork.org) Received: from nsmjustinlong [159.26.240.128] by mail.STRATEGICNETWORK.ORG (SMTPD32-5.00) id A4CF1A800D8; Thu, 22 Apr 1999 10:40:15 EDT Reply-To: From: "Justin Long" To: Subject: SELECT TOP _x_ ?? Date: Thu, 22 Apr 1999 10:33:02 -0400 Message-ID: <000401be8ccd$06c7e320$0a411a9f@cbn.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Importance: Normal In Microsoft SQL Server you could issue a command SELECT TOP 5 * FROM database... The top 5 indicator would mean to take the top 5 records that matched the criteria. I can't seem to find any way to do this in PostgreSQL. I have a database of 385 records (which will grow rapidly over the next few months) and it takes better than 5 seconds to SELECT from the 385 and then use a while loop to display the top 4. I can't imagine what it will be like when we reach, say, 10,000 records! So any suggestions for selecting just the top 5 and speeding the process up a bit? Any responses will be greatly appreciated. Respond here or to JustinLong@strategicnetwork.org ... Never retreat. Never surrender. Never cut a deal with a dragon. _______________________________________________________________ Justin Long CIO / Site Editor 616 Station Square Ct Network for Strategic Missions Chesapeake, VA 23320 977 Centerville Trnpk CSB 317 JustinLong@xc.org Va Beach, VA 23463 Check out our site at: http://www.strategicnetwork.org