Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 9E1EB2E3E6D
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  9 Jan 2008 23:14:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 02353-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  9 Jan 2008 23:13:49 -0400 (AST)
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.176])
	by postgresql.org (Postfix) with ESMTP id F15D42E3E76
	for <pgsql-sql@postgresql.org>; Wed,  9 Jan 2008 23:13:57 -0400 (AST)
Received: by py-out-1112.google.com with SMTP id d37so762830pye.29
	for <pgsql-sql@postgresql.org>; Wed, 09 Jan 2008 19:13:56 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=EdULkl6KeMZMpgtTSm0jRWeH5MpmH6dOyZ6vkNk8XWM=;
	b=hHiz5spVqc4trWu3IklDPZYJcu86Q/CrkOqspo7cPWowk+M41PghGrku/krGM0eH9Wczl0nNQf0jlvaIlDnvjme8JGT1u+9Qyro+V/7d3xH2bs7B0shAQeB76xoRYR6H35KPnr888RXSO5sJveLNdtM5+2AvuNfNvV2Z05Q3+CA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=jkYtRVYk1TQ63mTQbn26xmmqn3oQgSbcB4986OnCL5hQF36dl1OEHEsw6okACb12pD3YyKu5lUXPiTEh/dQR1w/keAVdpk1ecq0AJUTHRhl3wYW+sQq0dEaKJ/eJKB9p2reAFfgd7FzjP6WBRlW2s4l+2HHBm7r+902ZGoOSLCg=
Received: by 10.35.32.3 with SMTP id k3mr1653467pyj.18.1199934836343;
	Wed, 09 Jan 2008 19:13:56 -0800 (PST)
Received: by 10.35.44.18 with HTTP; Wed, 9 Jan 2008 19:13:56 -0800 (PST)
Message-ID: <f5ba57b40801091913y53833e1dh78592e5bc4a24d57@mail.gmail.com>
Date: Wed, 9 Jan 2008 22:13:56 -0500
From: "Chinyi Woo" <chinyi.woo@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Support for SQL TOP clause?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_9676_27966804.1199934836333"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/60
X-Sequence-Number: 29913

------=_Part_9676_27966804.1199934836333
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello, everyone
Does Postgresql support query like SELECT *TOP 3* * FROM Individual  ? If I
use ORDER BY, I have to write non-sql code to get the first row in the
result set, which I try to avoid.

Thanks
Chinyi

------=_Part_9676_27966804.1199934836333
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hello, everyone</div>
<div>Does Postgresql support query like SELECT <b>TOP 3</b> * FROM Individual&nbsp; ? If I use ORDER BY, I have to write non-sql code to get the first row in the result set, which I try to avoid.</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>Chinyi<br></div>

------=_Part_9676_27966804.1199934836333--