pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Justin Long <justinlong@strategicnetwork.org>
To: pgsql-sql@postgresql.org
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> (raw)
In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC145410@lambic.prevuenet.com>

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
>
>
>
>
>




view thread (6+ messages)  latest in thread

Message-ID: <001601be8d06$6055aba0$0a411a9f@cbn.org>
Permalink:  ../001601be8d06$6055aba0$0a411a9f@cbn.org/
Also on:    postgresql.org/message-id/001601be8d06$6055aba0$0a411a9f@cbn.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: justinlong@strategicnetwork.org
  Subject: Re: [SQL] SELECT TOP X -- part 2 -- parse error?
  In-Reply-To: <001601be8d06$6055aba0$0a411a9f@cbn.org>
  References: <93C04F1F5173D211A27900105AA8FCFC145410@lambic.prevuenet.com> <001601be8d06$6055aba0$0a411a9f@cbn.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox