pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael J Davis <michael.j.davis@tvguide.com>
To: 'justinlong@xc.org' <justinlong@xc.org>
To: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] SELECT TOP X -- part 2 -- parse error?
Date: Thu, 22 Apr 1999 16:42:33 -0500
Message-ID: <93C04F1F5173D211A27900105AA8FCFC145411@lambic.prevuenet.com> (raw)

I have successfully used limit 5.  You might try:
	SELECT * FROM table_name LIMIT 5;
rather than:
	SELECT * FROM database LIMIT 5;

	-----Original Message-----
	From:	Justin Long [SMTP:justinlong@strategicnetwork.org]
	Sent:	Thursday, April 22, 1999 3:24 PM
	To:	pgsql-sql@postgreSQL.org
	Subject:	RE: [SQL] SELECT TOP X -- part 2 -- parse error?

	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: <93C04F1F5173D211A27900105AA8FCFC145411@lambic.prevuenet.com>
Permalink:  ../93C04F1F5173D211A27900105AA8FCFC145411@lambic.prevuenet.com/
Also on:    postgresql.org/message-id/93C04F1F5173D211A27900105AA8FCFC145411@lambic.prevuenet.com

 · 

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: michael.j.davis@tvguide.com, justinlong@xc.org
  Subject: Re: [SQL] SELECT TOP X -- part 2 -- parse error?
  In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC145411@lambic.prevuenet.com>
  References: <93C04F1F5173D211A27900105AA8FCFC145411@lambic.prevuenet.com>

* 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