Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cBj5o-00041K-LP for pgsql-admin@arkaria.postgresql.org; Tue, 29 Nov 2016 14:09:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cBj5o-0002Gy-3T for pgsql-admin@arkaria.postgresql.org; Tue, 29 Nov 2016 14:09:08 +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 1cBj5m-0002Gd-1P for pgsql-admin@postgresql.org; Tue, 29 Nov 2016 14:09:07 +0000 Received: from m13-125.163.com ([220.181.13.125]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cBj5c-0004EO-SE for pgsql-admin@postgresql.org; Tue, 29 Nov 2016 14:09:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:MIME-Version:Message-ID; bh=SqlR9 9xziD+ezprDchhAj67tSn5laDXEGlztJCtFiM4=; b=ADob0zVMV1U+eCb5CXHeO girK1aNpiK8vC50ayeElirIbH6PpQkri+V+YhI3H7yi3XaZHCZXMLHTI2dtwW85x Q6rVxZst1vDDOnOF+pGt4SHu+alK08XJ0hSwcwiu91icLB9m/gsDsfHwK3z7yCHR pVfPnJrifkwMNSXfRQAPLE= Received: from taizi2006blog$163.com ( [113.105.172.153] ) by ajax-webmail-wmsvr125 (Coremail) ; Tue, 29 Nov 2016 22:08:50 +0800 (CST) X-Originating-IP: [113.105.172.153] Date: Tue, 29 Nov 2016 22:08:50 +0800 (CST) From: taizi To: pgsql-admin@postgresql.org Subject: How to query by month? X-Priority: 3 X-Mailer: Coremail Webmail Server Version SP_ntes V3.5 build 20160729(86883.8884) Copyright (c) 2002-2016 www.mailtech.cn 163com X-CM-CTRLDATA: 3k4cn2Zvb3Rlcl9odG09NzU5OjU2 Content-Type: multipart/alternative; boundary="----=_Part_171225_972855662.1480428530404" MIME-Version: 1.0 Message-ID: <35257d1c.b253.158b06aaae5.Coremail.taizi2006blog@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: fcGowEApmkLziz1YSWVoAA--.37349W X-CM-SenderInfo: xwdl6xasqqluxorjqiywtou0bp/1tbiZQgxi1WBThmG3wACsP X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== X-Pg-Spam-Score: -4.9 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_171225_972855662.1480428530404 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGkgYWxsLAppbSBhIGJlZ2lubmVyIGZvciBTUUwsIGFuZCAgdHJ5aW5nIHRvIHVzZSBpdCB3aXRo IG15IGRhaWx5IHdvcmsuCk5vdyBpIGNhdGNoZWQgdGhpcyBxdWVzdGlvbihteSB0aXRsZSBvZiBt YWlsKS4KU3VwcG9zZSB0aGVyZSBpcyBhIHRhYmxlIGFib3V0IG9yZGVycywgaSB3YW50IHRvIHN1 bSB0aGUgdG90YWwgYW1vdW50IG9mIGVhY2ggbW9udGguClRoZXJlIHdhcyBhIHN0YXRlbWVudCBv ZiBtaW5lIHRvIG5vdmVtYmVyLgpzZWxlY3QgIHN1bShvcmRlcl9hbW91bnQpIEZST00gdGFibGVf bmFtZSBXSEVSRSBvcmRlcl9kYXRlIGJldHdlZW4gJzIwMTYtMTEtMDEnIEFORCAnMjAxNi0xMS0z MCc7Ckkga25vdyBpdCBjb21lcyBhIHJlc3VsdCB3aGF0IGkgd2FudCwgYnV0IGkgaG9wZSBzb21l b25lIGNhbiB0ZWxsIG1lIGFub3RoZXIgd2F5IHRvIHVzZS4KQWZ0ZXIgc2VhcmNoZWQsIGkgZm91 bmQgIHRoZXJlIGlzIGEgZnVuY3Rpb24gbmFtZWQgZGF0ZV9wYXJ0LCBidXQgaXQgZG9lc24ndCB3 b3JrLgp0aGFua3MgZm9yIGFueSBoZWxwIQpMZW9wb2xkCgo= ------=_Part_171225_972855662.1480428530404 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXY+SGkgYWxsLDwvZGl2PjxkaXY+aW0gYSBiZWdpbm5lciBm b3IgU1FMLCBhbmQgJm5ic3A7dHJ5aW5nIHRvIHVzZSBpdCB3aXRoIG15IGRhaWx5IHdvcmsuPC9k aXY+PGRpdj5Ob3cgaSBjYXRjaGVkIHRoaXMgcXVlc3Rpb24obXkgdGl0bGUgb2YgbWFpbCkuPC9k aXY+PGRpdj5TdXBwb3NlIHRoZXJlIGlzIGEgdGFibGUgYWJvdXQgb3JkZXJzLCBpIHdhbnQgdG8g c3VtIHRoZSB0b3RhbCBhbW91bnQgb2YgZWFjaCBtb250aC48L2Rpdj48ZGl2PlRoZXJlIHdhcyBh IHN0YXRlbWVudCBvZiBtaW5lIHRvIG5vdmVtYmVyLjwvZGl2PjxkaXY+c2VsZWN0ICZuYnNwO3N1 bShvcmRlcl9hbW91bnQpIEZST00gdGFibGVfbmFtZSBXSEVSRSBvcmRlcl9kYXRlIGJldHdlZW4g JzIwMTYtMTEtMDEnIEFORCAnMjAxNi0xMS0zMCc7PC9kaXY+PGRpdj5JIGtub3cgaXQgY29tZXMg YSByZXN1bHQgd2hhdCBpIHdhbnQsIGJ1dCBpIGhvcGUgc29tZW9uZSBjYW4gdGVsbCBtZSBhbm90 aGVyIHdheSB0byB1c2UuPC9kaXY+PGRpdj5BZnRlciBzZWFyY2hlZCwgaSBmb3VuZCAmbmJzcDt0 aGVyZSBpcyBhIGZ1bmN0aW9uIG5hbWVkIGRhdGVfcGFydCwgYnV0IGl0IGRvZXNuJ3Qgd29yay48 L2Rpdj48ZGl2PnRoYW5rcyBmb3IgYW55IGhlbHAhPC9kaXY+PGRpdj5MZW9wb2xkPC9kaXY+PGRp dj48YnI+PC9kaXY+PC9kaXY+PGJyPjxicj48c3BhbiB0aXRsZT0ibmV0ZWFzZWZvb3RlciI+PHA+ Jm5ic3A7PC9wPjwvc3Bhbj4= ------=_Part_171225_972855662.1480428530404--