Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ainyQ-00015G-5o for pgsql-sql@arkaria.postgresql.org; Wed, 23 Mar 2016 18:57:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ainyP-0003bM-Oj for pgsql-sql@arkaria.postgresql.org; Wed, 23 Mar 2016 18:57:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ainyN-0003Vf-Aj for pgsql-sql@postgresql.org; Wed, 23 Mar 2016 18:57:39 +0000 Received: from mail-by2on0139.outbound.protection.outlook.com ([207.46.100.139] helo=na01-by2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ainyJ-0008HS-BB for pgsql-sql@postgresql.org; Wed, 23 Mar 2016 18:57:38 +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=ecyKlLsmMcMeQ2DAIIGJ4bRW6uX7Ezy2c9NfIUwYYTM=; b=FQ+2fL61mrX6vN4IUt8JRpBKAsiRgIZIU8p1LAODQKIGPRe1eZNCCwrX9ozlWdMR64gCztU1701BJv6fL8uMUHX+sMlIsZLHwyVsBQCr/1zSlWPwYWGpNJ6g6KTYaDXH8lyvEkk/48q+qHGV8C80FAsg1ZFlQQCOxVl7KmJUCZI= Received: from DM2PR0701MB1295.namprd07.prod.outlook.com (10.161.225.21) by DM2PR0701MB1295.namprd07.prod.outlook.com (10.161.225.21) with Microsoft SMTP Server (TLS) id 15.1.434.16; Wed, 23 Mar 2016 18:57:30 +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:57:30 +0000 From: Stephen Tahmosh To: Rob Sargent , "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: AQHRhS4K3GVLW3rMJUaV31fSWeoAy59nWLQAgAAIUNA= Date: Wed, 23 Mar 2016 18:57:30 +0000 Message-ID: References: <56F2D9C4.9010304@encs.concordia.ca> <56F2DFDC.2020408@gmail.com> In-Reply-To: <56F2DFDC.2020408@gmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=shieldsrx.com; x-originating-ip: [74.200.64.20] x-ms-office365-filtering-correlation-id: 37d693e9-f9a0-4185-e4d1-08d3534cfc8c x-microsoft-exchange-diagnostics: 1;DM2PR0701MB1295;5:QdlYOBnN3DXW9rwheDXyxTguATQvxuRkEkphIciH/La8NDCuSj/9kEUpKOaH4Mgmrp8zTMTV2zoSZgrDu06YdplFeQCgeywjyJWjaEXoUjII/SsS1FFOdacnLcACzlKhGvF5XJ5769tIRWeOhupwDA==;24:6ZxjvFHSsd4GXZaXA678ds0+mOqEYQhURbZP0/OcYq3y6giAAPKTwCDemoh31XWviTSbMRd88RPkGTjvxGDUkJK2+CZo/xzRB0kVHpfdQa4= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0701MB1295; 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)(10201501046)(3002001)(6041046)(6043046);SRVR:DM2PR0701MB1295;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0701MB1295; x-forefront-prvs: 08902E536D x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(13464003)(377454003)(24454002)(87936001)(33656002)(86362001)(19580405001)(19580395003)(76176999)(54356999)(50986999)(2906002)(66066001)(81166005)(3660700001)(92566002)(10400500002)(5001770100001)(99286002)(74316001)(106116001)(189998001)(107886002)(5890100001)(2501003)(11100500001)(586003)(3280700002)(5004730100002)(102836003)(6116002)(2950100001)(3846002)(5008740100001)(1220700001)(1096002)(5003600100002)(1720100001)(77096005)(15975445007)(122556002)(76576001)(5002640100001)(2900100001);DIR:OUT;SFP:1102;SCL:1;SRVR:DM2PR0701MB1295;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:57:30.7208 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 2a847002-624a-4855-9126-e7e855f88f37 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM2PR0701MB1295 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 DQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBwZ3NxbC1z cWwtb3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3NxbC1zcWwtb3du ZXJAcG9zdGdyZXNxbC5vcmddIE9uIEJlaGFsZiBPZiBSb2IgU2FyZ2VudA0K U2VudDogV2VkbmVzZGF5LCBNYXJjaCAyMywgMjAxNiAyOjI3IFBNDQpUbzog cGdzcWwtc3FsQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogW1NRTF0g cXVlcnkgYmFzZWQgb24gcm93IG51bWJlciBmb3IgcHNxbDguMw0KDQoNCg0K T24gMDMvMjMvMjAxNiAxMjowMCBQTSwgRW1pIHdyb3RlOg0KPiBIZWxsbywN Cj4NCj4gRm9yIHBzcWw4LjMsIGlzIHRoZXJlIGEgc2ltcGxlIHdheSB0byBx dWVyeSBiYXNlZCBvbiByb3cgbnVtYmVyIHBsZWFzZT8NCj4NCj4gRm9yIGV4 YW1wbGUsDQo+DQo+IHNlbGVjdCAgY2FzZQ0KPiAgICAgICAgICAgICAgICAg ICAgIHdoZW4gcm93X251bT0xIFRIRU4gICAgdDEudG90X2hyDQo+ICAgICAg ICAgICAgICAgICAgICAgRUxTRSB0MS50b3RfaHIgLSB0MS5wcmVfaHINCj4g ICAgICAgICAgIEVORA0KPiBGUk9NICB0MSA7DQo+DQo+DQo+DQo+DQo+DQpJ IHNlZW0gdG8gcmVjYWxsIG90aGVyIHBvc3RzIGZyb20gY29uZG9yZGlhOiAg U29tZW9uZSBuZWVkcyB0byB0YWtlIG9mDQp0aGVpciBza2F0ZXMgYW5kIHVw ZGF0ZSBwb3N0Z3JlcyENCg0KW1NUXQ0KSSdtIG5vdCAgc3VyZSBpZiB0aGlz IGxpbmsgd29ya3MsIGFzIEkgZG9uJ3QgaGF2ZSBhY2Nlc3MgdG8gOC4zDQpo dHRwOi8vcG9zdGdyZXNxbC5uYWJibGUuY29tL0hvdy10by1yZWFsaXplLVJP Vy1OVU1CRVItaW4tOC0zLXRkNDMyODQ0OC5odG1sDQoNCklmIHRoaXMgd29y a3MsIHRoZW4gd3JhcCB0aGUgcXVlcnkgd2l0aCBhIG1haW4gcXVlcnkgdGhh dCB1c2VzICJyb3dudW0iIGluIHRoZSBjYXNlIHN0YXRlbWVudC4NCg0KU1Rl dmUNCg0KDQoNCi0tDQpTZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBsaXN0 IChwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcpDQpUbyBtYWtlIGNoYW5nZXMg dG8geW91ciBzdWJzY3JpcHRpb246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwu b3JnL21haWxwcmVmL3Bnc3FsLXNxbA0KVEhJUyBNRVNTQUdFIChBTkQgQUxM IEFUVEFDSE1FTlRTKSBJUyBJTlRFTkRFRCBGT1IgVEhFIFVTRSBPRiBUSEUg UEVSU09OIE9SIEVOVElUWSBUTyBXSE9NIElUIElTIEFERFJFU1NFRCBBTkQg TUFZIENPTlRBSU4gSU5GT1JNQVRJT04gVEhBVCBJUyBQUklWSUxFR0VELCBD T05GSURFTlRJQUwgQU5EIEVYRU1QVCBGUk9NIERJU0NMT1NVUkUgVU5ERVIg QVBQTElDQUJMRSBMQVcuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCBy ZWNpcGllbnQsIHlvdXIgdXNlIG9mIHRoaXMgbWVzc2FnZSBmb3IgYW55IHB1 cnBvc2UgaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gSWYgeW91IGhhdmUgcmVj ZWl2ZWQgdGhpcyBjb21tdW5pY2F0aW9uIGluIGVycm9yLCBwbGVhc2UgZGVs ZXRlIHRoZSBtZXNzYWdlIHdpdGhvdXQgbWFraW5nIGFueSBjb3BpZXMgYW5k IG5vdGlmeSB0aGUgc2VuZGVyIHNvIHRoYXQgd2UgbWF5IGNvcnJlY3Qgb3Vy IHJlY29yZHMuIFRoYW5rIHlvdS4NCgotLSAKU2VudCB2aWEgcGdzcWwtc3Fs IG1haWxpbmcgbGlzdCAocGdzcWwtc3FsQHBvc3RncmVzcWwub3JnKQpUbyBt YWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cu cG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtc3FsCg==