Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ainIU-0007ng-Np for pgsql-sql@arkaria.postgresql.org; Wed, 23 Mar 2016 18:14:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ainIU-0002x6-A9 for pgsql-sql@arkaria.postgresql.org; Wed, 23 Mar 2016 18:14:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ainHV-0001US-2E for pgsql-sql@postgresql.org; Wed, 23 Mar 2016 18:13:21 +0000 Received: from mail-bl2on0138.outbound.protection.outlook.com ([65.55.169.138] helo=na01-bl2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ainHR-00071C-4t for pgsql-sql@postgresql.org; Wed, 23 Mar 2016 18:13:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=appriver3651004429.onmicrosoft.com; s=selector1-shieldsrx-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=p+eygDGuj91OtNGC258bQ55nkvQUT1JPkrLFrS/fm78=; b=UYhEy2rwaClQxY4zcfOCNMkR6gkQeHumnE+WuwmD4ZWNzDIv7oR9Thir26ql+lpkujLAuHRVofHgAm+onBcE/3USm0xtDF1Gi2TUtIdJpG025k7RkT9YXgQ63IYNIopgMGa03UpDjekmZfigZycgDzt9qDwP1CXtittVHSQSEzg= Received: from DM2PR0701MB1295.namprd07.prod.outlook.com (10.161.225.21) by DM2PR0701MB1293.namprd07.prod.outlook.com (10.161.225.19) with Microsoft SMTP Server (TLS) id 15.1.434.16; Wed, 23 Mar 2016 18:13:15 +0000 Received: from DM2PR0701MB1295.namprd07.prod.outlook.com ([10.161.225.21]) by DM2PR0701MB1295.namprd07.prod.outlook.com ([10.161.225.21]) with mapi id 15.01.0434.022; Wed, 23 Mar 2016 18:13:15 +0000 From: Stephen Tahmosh To: Stephen Tahmosh , "emilu@encs.concordia.ca" , "pgsql-sql@postgresql.org" Subject: Re: query based on row number for psql8.3 Thread-Topic: [SQL] query based on row number for psql8.3 Thread-Index: AQHRhS4K3GVLW3rMJUaV31fSWeoAy59nU4tAgAABF6A= Date: Wed, 23 Mar 2016 18:13:15 +0000 Message-ID: References: <56F2D9C4.9010304@encs.concordia.ca> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: shieldsrx.com; dkim=none (message not signed) header.d=none;shieldsrx.com; dmarc=none action=none header.from=shieldsrx.com; x-originating-ip: [74.200.64.20] x-ms-office365-filtering-correlation-id: 3629bfa8-6e32-4090-7d8d-08d35346cde4 x-microsoft-exchange-diagnostics: 1;DM2PR0701MB1293;5:ZLIEy42eMpsz0aqQwJWL+JI0/QgchH0MQBxbJXWOthd7RLTTVhST3pIGy2XAx8teipUrvdr9L916f8JqlXeDfiqilrjtQAqm6FjuwP1iNY+CzUu8+DvF6KBfqx0m+Tpy3pLlvH2PgSweJgeJ11yxMg==;24:F8JGD0l3GUXiHHKtrKwJvmbaK3CD6/6UzmkunwaZYdAriq+ReM2XAQHFErzlEw+r4JFq/YlgRTzqL6/4Cnrm3MKcJqrV1vbdhQ5fCnnBimU= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0701MB1293; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040046)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041046)(6043046);SRVR:DM2PR0701MB1293;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0701MB1293; x-forefront-prvs: 08902E536D x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(377454003)(13464003)(5001770100001)(1720100001)(87936001)(50986999)(76176999)(54356999)(33656002)(5002640100001)(2201001)(11100500001)(77096005)(19580395003)(19580405001)(86362001)(122556002)(5003600100002)(92566002)(81166005)(10400500002)(66066001)(3280700002)(5008740100001)(189998001)(3660700001)(74316001)(2906002)(76576001)(99286002)(2950100001)(2900100001)(3846002)(586003)(1220700001)(15975445007)(6116002)(1096002)(102836003)(5890100001)(2501003)(5004730100002)(107886002)(106116001);DIR:OUT;SFP:1102;SCL:1;SRVR:DM2PR0701MB1293;H:DM2PR0701MB1295.namprd07.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: shieldsrx.com X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Mar 2016 18:13:15.4616 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 2a847002-624a-4855-9126-e7e855f88f37 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM2PR0701MB1293 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org QSAiZ29nZ2xlIiBvZiByb3dfbnVtYmVyKCkgIGZ1bmN0aW9uIGZvciBwb3N0 Z3Jlc3FsIHNlZW1zIHRvIGluZGljYXRlIGl0cyBvbmx5IGF2YWlsYWJsZSBp biA4LjQgYW5kIGFib3ZlIDotKA0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut LS0tLQ0KRnJvbTogcGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwub3JnIFtt YWlsdG86cGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwub3JnXSBPbiBCZWhh bGYgT2YgU3RlcGhlbiBUYWhtb3NoDQpTZW50OiBXZWRuZXNkYXksIE1hcmNo IDIzLCAyMDE2IDI6MTAgUE0NClRvOiBlbWlsdUBlbmNzLmNvbmNvcmRpYS5j YTsgcGdzcWwtc3FsQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogW1NR TF0gcXVlcnkgYmFzZWQgb24gcm93IG51bWJlciBmb3IgcHNxbDguMw0KDQpS b3dfbnVtYmVyIGlzIGFuICJhbmFseXRpYyIgZnVuY3Rpb24sIHVzZWQgaW4g Y29uanVuY3Rpb24gd2l0aCB0aGUgInBhcnRpdGlvbiBieSINClJvcl9udW1i ZXIgaXMgYSBsb2dpY2FsIGNvbmNlcHQgc28gZGVwZW5kcyBvbiB0aGUgIm9y ZGVyIGJ5IiBjb21wb25lbnQgb2YgdGhlICJwYXJ0aXRpb24gYnkiIGNsYXVz ZQ0KDQpZb3UgbmVlZCB0byB3cmFwIHlvdXIgcXVlcnkgd2l0aCByb3dfbnVt YmVyIGluIGFuIG91dGVyIHF1ZXJ5IGFuZCBhcHBseSB0aHllIGNhc2Ugc3Rh dGVtZW50IHRvIHRoZSBvdXRlciBxdWVyeS4NCg0KLS0tLS1PcmlnaW5hbCBN ZXNzYWdlLS0tLS0NCkZyb206IHBnc3FsLXNxbC1vd25lckBwb3N0Z3Jlc3Fs Lm9yZyBbbWFpbHRvOnBnc3FsLXNxbC1vd25lckBwb3N0Z3Jlc3FsLm9yZ10g T24gQmVoYWxmIE9mIEVtaQ0KU2VudDogV2VkbmVzZGF5LCBNYXJjaCAyMywg MjAxNiAyOjAxIFBNDQpUbzogcGdzcWwtc3FsQHBvc3RncmVzcWwub3JnDQpT dWJqZWN0OiBbU1FMXSBxdWVyeSBiYXNlZCBvbiByb3cgbnVtYmVyIGZvciBw c3FsOC4zDQoNCkhlbGxvLA0KDQpGb3IgcHNxbDguMywgaXMgdGhlcmUgYSBz aW1wbGUgd2F5IHRvIHF1ZXJ5IGJhc2VkIG9uIHJvdyBudW1iZXIgcGxlYXNl Pw0KDQpGb3IgZXhhbXBsZSwNCg0Kc2VsZWN0ICBjYXNlDQogICAgICAgICAg ICAgICAgICAgICB3aGVuIHJvd19udW09MSBUSEVOICAgIHQxLnRvdF9ocg0K ICAgICAgICAgICAgICAgICAgICAgRUxTRSAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICB0MS50b3RfaHIgLQ0KdDEucHJlX2hyDQogICAgICAg ICAgIEVORA0KRlJPTSAgdDEgOw0KDQoNCg0KDQoNCi0tDQpTZW50IHZpYSBw Z3NxbC1zcWwgbWFpbGluZyBsaXN0IChwZ3NxbC1zcWxAcG9zdGdyZXNxbC5v cmcpDQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246DQpo dHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXNxbA0K VEhJUyBNRVNTQUdFIChBTkQgQUxMIEFUVEFDSE1FTlRTKSBJUyBJTlRFTkRF RCBGT1IgVEhFIFVTRSBPRiBUSEUgUEVSU09OIE9SIEVOVElUWSBUTyBXSE9N IElUIElTIEFERFJFU1NFRCBBTkQgTUFZIENPTlRBSU4gSU5GT1JNQVRJT04g VEhBVCBJUyBQUklWSUxFR0VELCBDT05GSURFTlRJQUwgQU5EIEVYRU1QVCBG Uk9NIERJU0NMT1NVUkUgVU5ERVIgQVBQTElDQUJMRSBMQVcuIElmIHlvdSBh cmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHlvdXIgdXNlIG9mIHRo aXMgbWVzc2FnZSBmb3IgYW55IHB1cnBvc2UgaXMgc3RyaWN0bHkgcHJvaGli aXRlZC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBjb21tdW5pY2F0aW9u IGluIGVycm9yLCBwbGVhc2UgZGVsZXRlIHRoZSBtZXNzYWdlIHdpdGhvdXQg bWFraW5nIGFueSBjb3BpZXMgYW5kIG5vdGlmeSB0aGUgc2VuZGVyIHNvIHRo YXQgd2UgbWF5IGNvcnJlY3Qgb3VyIHJlY29yZHMuIFRoYW5rIHlvdS4NCg0K LS0NClNlbnQgdmlhIHBnc3FsLXNxbCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNx bEBwb3N0Z3Jlc3FsLm9yZykNClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1 YnNjcmlwdGlvbjoNCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHBy ZWYvcGdzcWwtc3FsDQpUSElTIE1FU1NBR0UgKEFORCBBTEwgQVRUQUNITUVO VFMpIElTIElOVEVOREVEIEZPUiBUSEUgVVNFIE9GIFRIRSBQRVJTT04gT1Ig RU5USVRZIFRPIFdIT00gSVQgSVMgQUREUkVTU0VEIEFORCBNQVkgQ09OVEFJ TiBJTkZPUk1BVElPTiBUSEFUIElTIFBSSVZJTEVHRUQsIENPTkZJREVOVElB TCBBTkQgRVhFTVBUIEZST00gRElTQ0xPU1VSRSBVTkRFUiBBUFBMSUNBQkxF IExBVy4gSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCwg eW91ciB1c2Ugb2YgdGhpcyBtZXNzYWdlIGZvciBhbnkgcHVycG9zZSBpcyBz dHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlz IGNvbW11bmljYXRpb24gaW4gZXJyb3IsIHBsZWFzZSBkZWxldGUgdGhlIG1l c3NhZ2Ugd2l0aG91dCBtYWtpbmcgYW55IGNvcGllcyBhbmQgbm90aWZ5IHRo ZSBzZW5kZXIgc28gdGhhdCB3ZSBtYXkgY29ycmVjdCBvdXIgcmVjb3Jkcy4g VGhhbmsgeW91Lg0KCi0tIApTZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBs aXN0IChwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdl cyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3Fs Lm9yZy9tYWlscHJlZi9wZ3NxbC1zcWwK