[Pgsql-ayuda] consultas agrupando porfecha

[MAURICIO ALEJANDRO MORENO CASTRO]

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C30DDF.4587C660
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

hola a todos 


Espero que me puedan ayudar, soy nuevo usando postgres y deseo realizar una
consluta sobre una table agrupando por meses que me sume alfinal un valor
ejemplo : una taba de pagos que sume los valores por cada mes.

gracias oracoaboracion,

Mauricio Alejandro Moreno Castro


------=_NextPart_000_0000_01C30DDF.4587C660
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+IhwEAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANMHBAAcABcAJgAAAAEAOAEB
A5AGAPQFAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAHQAAAGNvbnN1bHRhcyBhZ3J1cGFuZG8gcG9yZmVjaGEAAAAAAgFxAAEAAAAWAAAAAcMOCSS9
LvtkrHCsRu+rU8ZmiyqMQAAAAgEdDAEAAAAbAAAAU01UUDpNQVVSSUNJT01AQU5ESU5FVC5DT00A
AAsAAQ4AAAAAQAAGDgDE9xwJDsMBAgEKDgEAAAAYAAAAAAAAAJWETnZRH4RCoWpdw4C4LsHCgAAA
CwAfDgEAAAACAQkQAQAAAKEBAACdAQAAPgIAAExaRnVMualsAwAKAHJjcGcxMjUGMgD4C2BuZzky
Mp42AfcCpAPjAgBjaArA4HNldDAgBxMCgwBQ9wTlEMkIUG0N4AYEBeACgzcOUAPVEXV9CoAIyCA7
WwlvDiA4AoAKgXYIkHfSawuAZDQMYGMAUAsDSQu1IGgG8GEgGdB0PQRwbwQhCrEKhBq2RXOicASQ
byBxClAgB4AUIHAKUGQDkWF5dQEcoHIsIHNveSDKbgpQdhvgdXMAcBow+xxgGkB0CcEEIB2AAQAR
ICcb4AlwB0BpegrBdW6/GdAFoACACkABkB1RYglwqyADAZFsHCBhCcB1CrCfHjQFwAeBB5EcBXN1
HEGdB0BmC4AHQCABIHYHQGEFsWVqZW0LUBvgOv8hNhnQAQAcYCHgGkEcAiOTnwkABCAkkweRIoJj
YRyg/SKyLhp6CcAA0AcwBCAFsK0A0G8BoCoSaQIgLBp+vQswYwBBAKAAQAXQYQhxtyqxEWAhsGoe
IRvRTSex6m4b4EMp4HQDYCwRAUB+aQLRDlAreQExGoMVcQABMNAAAAALAAGACCAGAAAAAADAAAAA
AAAARgAAAAADhQAAAAAAAAMAA4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAHgAggBgAA
AAAAwAAAAAAAAEYAAAAAUoUAAI5qAQAeAAmACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQA
AAA5LjAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AC4AIIAYAAAAA
AMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAAyACCAGAAAAAADAAAAAAAAARgAAAAA4hQAA
AQAAAAEAAAAAAAAACwANgAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALADqACCAGAAAAAADA
AAAAAAAARgAAAAAOhQAAAAAAAAMAPIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwA9gAgg
BgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAALAFWACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAA
AAMAVoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAAAgH4DwEAAAAQAAAAlYROdlEfhEKhal3D
gLguwQIB+g8BAAAAEAAAAJWETnZRH4RCoWpdw4C4LsECAfsPAQAAAHMAAAAAAAAAOKG7EAXlEBqh
uwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5ET1dTXEFw
cGxpY2F0aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QAAAMA/g8FAAAAAwAN
NP03AAACAX8AAQAAADUAAAA8SUVFQ0tCR0tNSUVITU9NT0hQTk9HRUxEQ0FBQS5tYXVyaWNpb21A
YW5kaW5ldC5jb20+AAAAAAMABhAFWT+5AwAHEOoAAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABl
AAAASE9MQUFUT0RPU0VTUEVST1FVRU1FUFVFREFOQVlVREFSLFNPWU5VRVZPVVNBTkRPUE9TVEdS
RVNZREVTRU9SRUFMSVpBUlVOQUNPTlNMVVRBU09CUkVVTkFUQUJMRUFHUlVQQQAAAACiOA==

------=_NextPart_000_0000_01C30DDF.4587C660--