Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EC48C2E2E87 for ; Wed, 9 Jan 2008 23:19:53 -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 03470-06 for ; Wed, 9 Jan 2008 23:19:41 -0400 (AST) Received: from weatherbeeta.com.au (unknown [218.214.212.154]) by postgresql.org (Postfix) with ESMTP id 2BD232E0363 for ; Wed, 9 Jan 2008 23:19:48 -0400 (AST) Received: (qmail 23823 invoked from network); 10 Jan 2008 03:19:46 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;678351ea78cc1af311432451087abdc5; Received: from mail.weatherbeeta.com.au (10.20.0.2) by network-box.weatherbeeta.com.au with SMTP; 10 Jan 2008 03:19:46 -0000 Received: (qmail 27832 invoked by uid 1166); 10 Jan 2008 14:19:44 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.20416 secs); 10 Jan 2008 03:19:44 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.20416 secs Process 27823) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 10 Jan 2008 14:19:43 +1100 From: "Phillip Smith" To: "'Chinyi Woo'" , Subject: Re: Support for SQL TOP clause? Date: Thu, 10 Jan 2008 14:19:43 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <00ab01c85337$a50ba690$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00AC_01C85393.D87C1E90" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Importance: Normal In-Reply-To: X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1199935186.344-23816-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.05 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.712 tagged_above=0 required=5 tests=AWL=-0.786, BAYES_50=0.001, HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=1.396, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200801/61 X-Sequence-Number: 29914 This is a multi-part message in MIME format. ------=_NextPart_000_00AC_01C85393.D87C1E90 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable SELECT * FROM Individual LIMIT 3 =20 I asked the reverse question moving from PG to MSSQL :-( =20 -----Original Message----- From: pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Chinyi Woo Sent: Thursday, 10 January 2008 14:14 To: pgsql-sql@postgresql.org Subject: [SQL] Support for SQL TOP clause? =20 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. =20 Thanks Chinyi =0ATHINK BEFORE YOU PRINT - Save paper if you don't really need to print this= =0A=0A*******************Confidentiality and Privilege Notice*******************= =0A=0AThe material contained in this message is privileged and confidential to= =0Athe addressee. If you are not the addressee indicated in this message or= =0Aresponsible for delivery of the message to such person, you may not copy=0Aor= deliver this message to anyone, and you should destroy it and kindly=0Anotify= the sender by reply email.=0A=0AInformation in this message that does not relat= e to the official business=0Aof Weatherbeeta must be treated as neither given = nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contractors or as= sociates shall not be liable=0Afor direct, indirect or consequential loss aris= ing from transmission of this=0Amessage or any attachments=0Ae-mail.=0A ------=_NextPart_000_00AC_01C85393.D87C1E90 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

SELECT *

FROM   = Individual

LIMIT 3

 

I asked the reverse question moving = from PG to MSSQL L

 

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] = On Behalf Of Chinyi Woo
Sent: Thursday, 10 = January 2008 14:14
To: = pgsql-sql@postgresql.org
Subject: [SQL] Support = for SQL TOP clause?

 

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


=

=0ATHINK BEFORE YOU PRINT - Save paper if you don't really need to print t= his e-mail.=0A

=0A*******************Confidentiality and Privilege Notice**= *****************=0A

=0AThe material contained in this message is privileg= ed and confidential to=0Athe addressee. If you are not the addressee indicate= d in this message or=0Aresponsible for delivery of the message to such person,= you may not copy=0Aor deliver this message to anyone, and you should destroy = it and kindly=0Anotify the sender by reply email.=0A

=0AInformation in this mess= age that does not relate to the official business=0Aof Weatherbeeta must be tr= eated as neither given nor endorsed by Weatherbeeta.=0AWeatherbeeta, its emplo= yees, contractors or associates shall not be liable=0Afor direct, indirect or = consequential loss arising from transmission of this=0Amessage or any attachme= nts=0A
= ------=_NextPart_000_00AC_01C85393.D87C1E90--