Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.1) with ESMTP id RAA16995 for ; Thu, 22 Apr 1999 17:17:05 -0400 (EDT) (envelope-from michael.j.davis@tvguide.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id JCBQ67PN; Thu, 22 Apr 1999 16:16:26 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Thu, 22 Apr 1999 16:19:26 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC145410@lambic.prevuenet.com> From: Michael J Davis To: "'justinlong@xc.org'" , pgsql-sql@hub.org Subject: RE: [SQL] SELECT TOP X -- part 2 -- parse error? Date: Thu, 22 Apr 1999 16:12:43 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" The LIMIT clause is new for version 6.5. You will need to upgrade to take advantage of "LIMIT". -----Original Message----- From: Justin Long [SMTP:justinlong@strategicnetwork.org] Sent: Thursday, April 22, 1999 12:53 PM To: pgsql-sql@hub.org Subject: [SQL] SELECT TOP X -- part 2 -- parse error? Thanks for the answers. I downloaded and installed PG5... now I have a new problem. I can't seem to access any documentation on the syntax of the new additions to PG5, and I'm getting a parse error with the following command SELECT * FROM database LIMIT 5 It says parse error at or near "5" Also PSQL seems to still say 6.4.2 and have all the 6.4.2 functions described in its help files. Is this indicative of a bad install? Everything I saw appeared to indicate PG5 had installed properly and this parse error leads me to think it is trying to interpret the LIMIT command but is having problems with syntax. Justin -----Original Message----- From: owner-pgsql-sql@postgreSQL.org [mailto:owner-pgsql-sql@postgreSQL.org] On Behalf Of Justin Long Sent: Thursday, April 22, 1999 10:33 AM To: pgsql-sql@hub.org Subject: [SQL] SELECT TOP _x_ ?? 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