Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZNNx8-0006SM-SW for pgsql-sql@arkaria.postgresql.org; Thu, 06 Aug 2015 16:23:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZNNx7-0007BE-KS for pgsql-sql@arkaria.postgresql.org; Thu, 06 Aug 2015 16:23:33 +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) (envelope-from ) id 1ZNNw9-00065v-6V for pgsql-sql@postgresql.org; Thu, 06 Aug 2015 16:22:33 +0000 Received: from mx.klingler.net ([213.193.121.99] helo=srv2012.klingler.net) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZNNw6-0002YE-2C for pgsql-sql@postgresql.org; Thu, 06 Aug 2015 16:22:32 +0000 Received: from SRV2012.klingler.net (10.0.1.1) by SRV2012.klingler.net (10.0.1.1) with Microsoft SMTP Server (TLS) id 15.0.847.32; Thu, 6 Aug 2015 18:16:34 +0200 Received: from SRV2012.klingler.net ([fe80::9d8f:eaf5:8d1c:f726]) by SRV2012.klingler.net ([fe80::9d8f:eaf5:8d1c:f726%12]) with mapi id 15.00.0847.030; Thu, 6 Aug 2015 18:16:34 +0200 From: "Richard RK. Klingler" To: "pgsql-sql@postgresql.org" Subject: Sales report by month and item category Thread-Topic: Sales report by month and item category Thread-Index: AQHQ0GNDI33ua7vwVEOdfbwQNndPyg== Date: Thu, 6 Aug 2015 16:16:33 +0000 Message-ID: <9FE72338-AD53-4A9B-B7FC-0129A0DF370D@klingler.net> Accept-Language: de-CH, de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.0.60.4] Content-Type: multipart/alternative; boundary="_000_9FE72338AD534A9BB7FC0129A0DF370Dklinglernet_" MIME-Version: 1.0 X-Pg-Spam-Score: -2.0 (--) 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 --_000_9FE72338AD534A9BB7FC0129A0DF370Dklinglernet_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGVsbG8NCg0KSSdtIGN1cnJlbnRseSB1c2luZyBmb2xsb3dpbmcgcXVlcnkgdG8gcmVwb3J0IHRo ZSBtb250aGx5IHJldmVudWUgb2YgYW4gb25saW5lIHNob3A6DQood2VsbOKApkkganVzdCB1c2Ug cGdzcWwgb24gYSBLSVNTIGJhc2lzIDtvKQ0KDQpzZWxlY3QgZGF0ZV90cnVuYygnbW9udGgnLCBv cmRlcnMub3JkZXJkYXRlKSBhcyBtb250aCwgc3VtKG9yZGVyaXRlbXMucHJpY2UgKiBvcmRlcml0 ZW1zLm9yZGVyaXRlbXMycXVhbnRpdHkpIGFzIHJldmVudWUNCmZyb20gb3JkZXJzLCBvcmRlcml0 ZW1zLCBwcm9kdWN0DQp3aGVyZSBvcmRlcml0ZW1zLm9yZGVyaXRlbXMyb3JkZXJpZCA9IG9yZGVy cy5vcmRlcmlkDQphbmQgb3JkZXJpdGVtcy5vcmRlcml0ZW1zMnByb2R1Y3RpZCA9IHByb2R1Y3Qu cHJvZHVjdGlkDQpncm91cCBieSBkYXRlX3RydW5jKCdtb250aCcsIG9yZGVycy5vcmRlcmRhdGUp DQpvcmRlciBieSBtb250aCBkZXNjOw0KDQpnaXZlczoNCg0KDQogICAgICAgICBtb250aCAgICAg ICAgICB8IHJldmVudWUNCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0NCg0K IDIwMTUtMDgtMDEgMDA6MDA6MDArMDIgfCAgMTk1Ni4wMA0KDQogMjAxNS0wNy0wMSAwMDowMDow MCswMiB8IDEzMDc5LjQwDQoNCiAyMDE1LTA2LTAxIDAwOjAwOjAwKzAyIHwgMTA4NjQuMjANCg0K DQoNCkJ1dCBhcyB0aGUgInByb2R1Y3QiIGl0ZW1zIGhhdmUgY2F0ZWdvcmllcyBhc3NpZ25lZCB0 byB0aGVtIEkgd291bGQgbGlrZSB0byBiZSBhYmxlIHRvIGFsc28NCnJlcG9ydCBiYXNlZCBvbiBj YXRlZ29yaWVzLCBzb21ldGhpbmcgbGlrZToNCg0KDQogICAgICAgICBtb250aCAgICAgICAgICB8 ICBiaWtlcyAgIHwgICBjYXJzICAgfCAgcGxhbmVzICB8IHN1Ym1hcmluZXMNCg0KLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0t LS0tLQ0KDQogMjAxNS0wOC0wMSAwMDowMDowMCswMiB8ICAyMzMuMDAgIHwgNDIxMS4wMCAgfCA3 ODMzLjUwICB8ICA3MjMuMzUNCg0KDQpTbyBmYXIgSSdtIHVzaW5nIHR3byBxdWVyaWVzIGNhbGxl ZCBpbiBhIGxvb3AgaW4gbXkgUEhQIGNvZGXigKYuYnV0IHRoZSBwcm9ibGVtIHRoZXJlIGlzIHRo YXQNCm5vdCBhbGwgY2F0ZWdvcmllcyByZXR1cm4gYSByZXZlbnVlIGZvciBhIHNwZWNpZmljIG1v bnRoIGlmICBub3RoaW5nIHdhcyBzb2xkIGluIHRoYXQgbW9udGguDQoNCg0KT3IgaXMgdGhhdCBu b3QgcG9zc2libGUgaW4gYSBtb3JlIG9yIGxlc3Mgc2ltcGxlIHF1ZXJ5Pw0KDQoNCg0KdGhhbmtz IGluIGFkdmFuY2UNCnJpY2hhcmQNCg0KDQo= --_000_9FE72338AD534A9BB7FC0129A0DF370Dklinglernet_ Content-Type: text/html; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjwvaGVhZD4NCjxib2R5IHN0eWxlPSJ3b3JkLXdy YXA6IGJyZWFrLXdvcmQ7IC13ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5lLWJy ZWFrOiBhZnRlci13aGl0ZS1zcGFjZTsgY29sb3I6IHJnYigwLCAwLCAwKTsgZm9udC1zaXplOiAx NHB4OyBmb250LWZhbWlseTogQ2FsaWJyaSwgc2Fucy1zZXJpZjsiPg0KPGRpdj5IZWxsbzwvZGl2 Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+SSdtIGN1cnJlbnRseSB1c2luZyBmb2xsb3dpbmcg cXVlcnkgdG8gcmVwb3J0IHRoZSBtb250aGx5IHJldmVudWUgb2YgYW4gb25saW5lIHNob3A6PC9k aXY+DQo8ZGl2Pih3ZWxs4oCmSSBqdXN0IHVzZSBwZ3NxbCBvbiBhIEtJU1MgYmFzaXMgO28pPC9k aXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj4NCjxkaXY+c2VsZWN0IGRhdGVfdHJ1bmMoJ21v bnRoJywgb3JkZXJzLm9yZGVyZGF0ZSkgYXMgbW9udGgsIHN1bShvcmRlcml0ZW1zLnByaWNlICog b3JkZXJpdGVtcy5vcmRlcml0ZW1zMnF1YW50aXR5KSBhcyByZXZlbnVlPC9kaXY+DQo8ZGl2PmZy b20gb3JkZXJzLCBvcmRlcml0ZW1zLCBwcm9kdWN0PC9kaXY+DQo8ZGl2PndoZXJlIG9yZGVyaXRl bXMub3JkZXJpdGVtczJvcmRlcmlkID0gb3JkZXJzLm9yZGVyaWQ8L2Rpdj4NCjxkaXY+YW5kIG9y ZGVyaXRlbXMub3JkZXJpdGVtczJwcm9kdWN0aWQgPSBwcm9kdWN0LnByb2R1Y3RpZDwvZGl2Pg0K PGRpdj5ncm91cCBieSBkYXRlX3RydW5jKCdtb250aCcsIG9yZGVycy5vcmRlcmRhdGUpPC9kaXY+ DQo8ZGl2Pm9yZGVyIGJ5IG1vbnRoIGRlc2M7PC9kaXY+DQo8L2Rpdj4NCjxkaXY+PGJyPg0KPC9k aXY+DQo8ZGl2PmdpdmVzOjwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+DQo8cCBzdHls ZT0ibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+Jm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwO21vbnRoJm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyB8IHJldmVudWUgJm5ic3A7PC9wPg0KPHAgc3R5bGU9Im1hcmdpbjogMHB4 OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLSYjNDM7LS0tLS0tLS0tLTwvcD4NCjxwIHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1z aXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJzcDsyMDE1LTA4LTAxIDAwOjAwOjAw JiM0MzswMiB8Jm5ic3A7IDE5NTYuMDA8L3A+DQo8cCBzdHlsZT0ibWFyZ2luOiAwcHg7IGZvbnQt c2l6ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+Jm5ic3A7MjAxNS0wNy0wMSAwMDowMDow MCYjNDM7MDIgfCAxMzA3OS40MDwvcD4NCjxwIHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXpl OiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJzcDsyMDE1LTA2LTAxIDAwOjAwOjAwJiM0 MzswMiB8IDEwODY0LjIwPC9wPg0KPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj48YnI+ DQo8L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2PkJ1dCBhcyB0aGUgJnF1b3Q7cHJvZHVj dCZxdW90OyBpdGVtcyBoYXZlIGNhdGVnb3JpZXMgYXNzaWduZWQgdG8gdGhlbSBJIHdvdWxkIGxp a2UgdG8gYmUgYWJsZSB0byBhbHNvPC9kaXY+DQo8ZGl2PnJlcG9ydCBiYXNlZCBvbiBjYXRlZ29y aWVzLCBzb21ldGhpbmcgbGlrZTo8L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2Pg0KPGRp dj4NCjxwIHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTog TWVubG87Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7bW9udGgmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7Jm5ic3A7fCAmbmJzcDtiaWtlcyAmbmJzcDsgfCAmbmJz cDsgY2FycyAmbmJzcDsgfCAmbmJzcDtwbGFuZXMgJm5ic3A7fCBzdWJtYXJpbmVzJm5ic3A7PC9w Pg0KPHAgc3R5bGU9Im1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBN ZW5sbzsiPi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSYjNDM7LS0tLS0tLS0tLSYjNDM7LS0tLS0t LS0tLSYjNDM7LS0tLS0tLS0tLSYjNDM7LS0tLS0tLS0tLS0tPC9wPg0KPHAgc3R5bGU9Im1hcmdp bjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPiZuYnNwOzIwMTUt MDgtMDEgMDA6MDA6MDAmIzQzOzAyIHwmbmJzcDsmbmJzcDsyMzMuMDAgJm5ic3A7fCA0MjExLjAw ICZuYnNwO3wgNzgzMy41MCAmbmJzcDt8ICZuYnNwOzcyMy4zNTwvcD4NCjxwIHN0eWxlPSJtYXJn aW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij48YnI+DQo8L3A+ DQo8L2Rpdj4NCjwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+U28gZmFyIEknbSB1c2lu ZyB0d28gcXVlcmllcyBjYWxsZWQgaW4gYSBsb29wIGluIG15IFBIUCBjb2Rl4oCmLmJ1dCB0aGUg cHJvYmxlbSB0aGVyZSBpcyB0aGF0PC9kaXY+DQo8ZGl2Pm5vdCBhbGwgY2F0ZWdvcmllcyByZXR1 cm4gYSByZXZlbnVlIGZvciBhIHNwZWNpZmljIG1vbnRoIGlmICZuYnNwO25vdGhpbmcgd2FzIHNv bGQgaW4gdGhhdCBtb250aC48L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2Pjxicj4NCjwv ZGl2Pg0KPGRpdj5PciBpcyB0aGF0IG5vdCBwb3NzaWJsZSBpbiBhIG1vcmUgb3IgbGVzcyBzaW1w bGUgcXVlcnk/PC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxk aXY+PGJyPg0KPC9kaXY+DQo8ZGl2PnRoYW5rcyBpbiBhZHZhbmNlPC9kaXY+DQo8ZGl2PnJpY2hh cmQ8L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj4NCjxk aXYgaWQ9Ik1BQ19PVVRMT09LX1NJR05BVFVSRSI+PC9kaXY+DQo8L2Rpdj4NCjwvYm9keT4NCjwv aHRtbD4NCg== --_000_9FE72338AD534A9BB7FC0129A0DF370Dklinglernet_--