Received: from mail.STRATEGICNETWORK.ORG ([216.1.60.176]) by hub.org (8.9.3/8.9.1) with ESMTP id RAA17989 for ; Thu, 22 Apr 1999 17:24:35 -0400 (EDT) (envelope-from justinlong@strategicnetwork.org) Received: from nsmjustinlong [159.26.240.128] by mail.STRATEGICNETWORK.ORG (SMTPD32-5.00) id A50B2710104; Thu, 22 Apr 1999 17:30:51 EDT Reply-To: From: "Justin Long" To: Subject: RE: [SQL] SELECT TOP X -- part 2 -- parse error? Date: Thu, 22 Apr 1999 17:23:33 -0400 Message-ID: <001601be8d06$6055aba0$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 Importance: Normal In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC145410@lambic.prevuenet.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 I did upgrade to Postgresql 6.5... and as far as I can tell the install was successful. As I noted it seems to be recognizing the LIMIT command... just hitting a parse error at the '5' modifier. Justin > -----Original Message----- > From: owner-pgsql-sql@postgreSQL.org > [mailto:owner-pgsql-sql@postgreSQL.org]On Behalf Of Michael J Davis > Sent: Thursday, April 22, 1999 5:13 PM > To: 'justinlong@xc.org'; pgsql-sql@hub.org > Subject: RE: [SQL] SELECT TOP X -- part 2 -- parse error? > > > 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 > > > > >