X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4019F9FA176 for ; Tue, 16 May 2006 10:05:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 61042-01 for ; Tue, 16 May 2006 10:04:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id CA01E9F9F8F for ; Tue, 16 May 2006 10:04:37 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k4GCvNLc021279; Tue, 16 May 2006 18:27:23 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id EC63A332695; Tue, 16 May 2006 18:27:22 +0530 (IST) Message-ID: <03f701c678ea$5e1124a0$cd00000a@sandhyar> From: "sandhya" To: Cc: , "Nabil Aziz Sawaya" References: Subject: Re: reg:Query Date: Tue, 16 May 2006 18:42:21 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_03F4_01C67918.77416BF0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.040 X-imss-result: Passed X-imss-scanInfo: M:P L:E SM:0 X-imss-tmaseResult: TT:0 TS:0.0000 TC:00 TRN:0 TV:3.51.1032(14006.000) X-imss-scores: Clean:57.14837 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.2500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/211 X-Sequence-Number: 21743 This is a multi-part message in MIME format. ------=_NextPart_000_03F4_01C67918.77416BF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you..... ----- Original Message -----=20 From: Andy Shellam=20 To: 'sandhya'=20 Cc: pgsql-admin@postgresql.org=20 Sent: Tuesday, May 16, 2006 6:26 PM Subject: RE: [ADMIN] reg:Query SELECT ... LIMIT 1 =20 Will get the first row in the dataset. Then to fetch the next row, = you can do SELECT .. LIMIT 1 OFFSET 1 (will get the 2nd record) and so = on. (replace ... with your conditions, LIMIT must come at the end of the = query) =20 Andy =20 -------------------------------------------------------------------------= ----- From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya Sent: 16 May 2006 11:47 am To: Postgres Cc: sandhya Subject: [ADMIN] reg:Query =20 Hi Is there any query for possibility of getting only one row at a time = in a group of records? =20 With distinct rows & Columns my query has to return only one record at = a time with out any condition.Will it be possible? =20 Thank you, Sandhya =20 !DSPAM:14,4469ca6434491997014324!=20 ------=_NextPart_000_03F4_01C67918.77416BF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you.....
----- Original Message -----
From:=20 Andy Shellam
Sent: Tuesday, May 16, 2006 = 6:26 PM
Subject: RE: [ADMIN] = reg:Query

SELECT = =85.. LIMIT=20 1

 

Will get = the first=20 row in the dataset.  Then to fetch the next row, you can do = SELECT =85=85=20 LIMIT 1 OFFSET 1 (will get the 2nd record) and so=20 on.

(replace = =85.. with=20 your conditions, LIMIT must come at the end of the=20 query)

 

Andy

 


From: pgsql-admin-owner@postgr= esql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of = sandhya
Sent: 16 May 2006 11:47 = am
To: Postgres
Cc: sandhya
Subject: [ADMIN]=20 reg:Query

 

Hi

 Is there any query for possibility of = getting=20 only one row at a time in a group of=20 records?

 

With distinct rows & Columns my query = has to=20 return only one record at a time with out any condition.Will it be=20 possible?

 

Thank = you,

Sandhya

 

!DSPAM:14,4469ca6434491997014324!=20

------=_NextPart_000_03F4_01C67918.77416BF0--