Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C4FB92E2F33 for ; Thu, 10 Jan 2008 07:46:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 05335-07 for ; Thu, 10 Jan 2008 07:46:16 -0400 (AST) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [82.95.228.65]) by postgresql.org (Postfix) with ESMTP id 8C22A2E2EC9 for ; Thu, 10 Jan 2008 07:46:26 -0400 (AST) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id B4BF71CD1A; Thu, 10 Jan 2008 12:46:23 +0100 (CET) Date: Thu, 10 Jan 2008 12:46:23 +0100 From: Reinoud van Leeuwen To: pgsql-sql@postgresql.org Subject: Re: Support for SQL TOP clause? Message-ID: <20080110114623.GF41164@spoetnik.xs4all.nl> Mail-Followup-To: pgsql-sql@postgresql.org References: <00ab01c85337$a50ba690$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00ab01c85337$a50ba690$9b0014ac@wbaus090> X-message-flag: Warning! The sender of this mail thinks you should use a more secure email client. User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/66 X-Sequence-Number: 29919 On Thu, Jan 10, 2008 at 02:19:43PM +1100, Phillip Smith wrote: > SELECT * > > FROM Individual > > LIMIT 3 Note that you will have to add an 'order by' clause to guarantee predictable results... -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________