window function v03 against HEAD

Started by H.Haradaover 17 years ago11 messages
#1H.Harada
umi.tanuki@gmail.com
1 attachment(s)

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

The window functions such like row_number(), rank(), dense_rank(),
percent_rank() are experimentally defined within the patch as
* It is formed as an aggregate function, seen in pg_aggregate
* It does or does not have trans function.
* It has a final function that is declared as VOLATILE.
* Its final function is called multiple times during returning values.

And ranking system is a bit ugly. The problem was how you know the
ranking boundary. Inside rank_final(), you see WindowState node is
pulled out from fcinfo->context and TupleTableSlot is used. Actually I
am not sure if this is appropriate but have tried it, which did work.
So as the first release, I guess it is better that the window
functions are formulated but not open as user-defined functions.
Also, since current design of the window functions is by aggregate,
some of the SQL spec functions such like lag()/lead() was dropped.
These functions need to reach for random rows from current row. For
this needs, we might have to provide something like Window Object
mechanism that allows random access to the current frame.

There's no additional docs and tests, as well as lack of comments in
source code. The "make check" will fail because some of the window
functions do not have trans function.

Reviews and comments are welcome. I'm eager to refine it.

Regards,

--
Hitoshi Harada

Attachments:

window_function_v03_patch.tgzapplication/x-gzip; name=window_function_v03_patch.tgzDownload
���k[I�0�_�����vS��!��=4`7;����g�y�R5*�J2�������DVe�v��}��� UeF�""#"##���8�^-��E�M�Z��,^�n6�����|��v������������ouZ�n�z��`0�T���w{���4_����\��g�������?T>=��G����y�[2Z.���i6N�jl���L:M��$X�f�h:N~�������x:���l�S�����������t�����y��d����>��~�g��������>����<M>��k5�?9 �jo�[k����H=��w������F�h����^uZ�m���m�v;;�"y��?{��!�m���	�hm��{�-
{ �G[��hk{K���|~��T�1��D]���t�KO�i|����z��?��'��k�/�.=r���.ij��~���bC���Nh4��v�����lw{�v��F��o�[��|1L�WY�y��"QO�L�4�/��T��G
:�L�J����[�Y�/'f���,�]��f�8���f�����?�a���;6]`Y�����i��"�Iz�N��IDu�9Y�{�O��5��PIL��GK����.RR	h���^&���Z���.���r���IF�����H�do?���x�S��Q<���CZ!�Q>�/>�[��B�J�W�i<1_��u���$�b�e3]����,F;��<�U��_k�H8����A���N�_�I�����2�E+�2��W�l9+�9_^"�F��y~/`\�c�m���A�GI�!���|�nf���WE����WEl��e��X~��M���_�D%���{Lj��\�+��-������~k��e���dS���Tw'�����_-�����OB3Ky�������"���FU1#"$���ip$��V�i��X:�><�[�!>K��IBi�b�����������EaW��K;��������MQ&}����qr;� �d�������H=YN��(������	�Z����m[|3�.�����������������zRIe��Ge��*���\�F[�g<������9��%7���A�����T~����;W�6����tj	��S����	�u�u�B���;Qg�dm@'Y]%W���(��(X����U�
�b�d�������hK�\��^n��C���'o��_4�$��d�@�
����4��yp�{�V�k����G�������J��H�����_i�s�5�F[�m����N�r<l9��0���tq>���Eokp4&�����%4U�v7��T
:�h���N�_
�4�?*������_��^T�����xw�Jt�v��2
�.���j���]��"���Vy�&�D���Z��M�#u/��DP������<�j��C�4���@�X@��W��t����A����,���i~��L"*|�M�0�����0�@Y��It�.�B_��S����t�b.~��M�2
�zk������$�?������F���<�.lh}��}�b���z��\>z�_���U�|w����B�Js��1_�+�2C�s;[.���@x�r|��)��yJ�HsH�zR6E�'pG(3Z{��\�5^&@������]�s![��_&�x	���1�iZ�����	�k��r>O���=w��L�����G� (�w,�^���
���h8�D�ghw�5L��~HF�V�{7�Ij���dq�F7��=���M3e�!gDH�<Y7��qA������/���� �+m�Z���z��Gn�KP��(�=��CS�����$�)���^�v�d{���;-yB� ���@�u�c���9`��R����`�7"�FVl��1b��b���o����
(�"�p�g?����L�Y�7<�s4=��)�t{#��o�UG���)!x����f�
����nAbcx��H[�g)��_���JM�|�y�w����>��76\���6���0�*�x�(�8yM�B|j�JE�:<6����o2����5�iu
\����rf�CQ^�Vu�V1���4�F0�POJ
�1�Nc��rE��X{�y|����h�c\����3��_�����/��" ��P)ww�3^��d���q	r�-���6�Mu:V:F��
�q�ce�m���tm+�?M�x������7�!��hU���*
OD)��^��[���Cb��'���{�04��L��8o��	!F�~��\��7��������/������dy��M4'�oN�N.Ex4�-"��~pu`�9���
��^&��:@��d�2���:M����l>~��P�����PONmg�������$��_{�w@�v��Xd���~��X����[���"?e��r*�����m�4���������[%M�'�$�tc�}A:E��L@�y%	��r��j��U�*�G�G'p��8ma�/g5E�[�������sq�9�O�����s����)����~?jo
��t�omG�~��0��m����|B��]i����V�{Xm��f�:���3=u�b��U.)������^��M<_�H���^4K�Y(�
�D��q6�4
�~��~"sz���"yK���R���7��a'��F{wq����_$ ���,�{��X�e"g���x���]�����B!����N�LfKHl�A
z�//�=���V��5X����x���t�A���8�J�4�U�&�(��C|28��~;�_�����s��U��(��]�`_n�|���_�//������
�X�4���"��$�w����'oa����1�Z�����zrJp�v���)��QmACz�U��ie������y���wN�����mUL*�L^11�v��/A$]����iu:�������O��Ws���kmG��5fG�
�O�����GG?*�y��:V�#���taX�viX���$�g�*�����A���2�����v`Y�v���w�Qw�*�$�.�Hl\�`&�(�)�fC@*�"AhE�"o�UKt^���t���������s��{�Y�4%����m@��F�N�7uz�����Hy�
��@��:"
p+�;	>��.��Z��s����jGR��������7{g��jg���<�D���^�?���
.Q�B��R�b�H�4�JO���N���t_.Y0T�B�1��3^������[�<�����'BV)J��bAA���aY2�J���N �wZ-)8�av����
�����A��AJ�jH����=8/���a�rG��w����V���<DE���x:-�;-)pw��^�i��!a@
cL��;����+J`���V�]%��G	��q ��N�3�Jr��N�'G����P�WK�*��F�>;<��8:=���;[t-�#G����</�B_��:��Rx2i��Y%/�!)O��)t`�r�a��c;��x)�`p�W�	��O�P�-_[$t]����=���@h�]���:�m)nW�BY���w�^���H�9x����@n�}��
�9����hz���Hs�GGqf��#����|gGzG����a�������w�{�s=��$���O����L���}�v�9�>�������^�T�;A�r�tc���`���������u���Q �J�^����+u���cz����t���	����+a>4��w����w����
l�m������V78�^��z�
 �Qn<�����Wg�/*s������x�4������G'U:�����8������N���T.�0�3������;;��E�_P��������~o�Frg�
Nh3���&S*�bJ��a���DO}!L�r�E#�����w0�*����]�g��������]���~�^���������*��-9'�mx�������T d/*��CK���KJF�p	a/�n�d�"���mT��eT�>i�,���\��N���������%�I�G�EN(^K�X<w
0$X��Z\�L�v��?^�Z�������J[�Ay�zH�/�*�1J%
V���y��X�'wV,g�����������_�}wP_A*��`���K�N���;��aP	n���v�S�{]P����#p|FB:��Q����]N*������ D�
YY�+"�4��X�jx��x)|�-�9h�0��azjP�+���4|�r���8
O�z��{h����~������V+0��)�,�V���Z���TM�>?k���*�<�FC��+MT�3ZeeC&�F������:��_�<"�P}����/�[J��i�@"J���o���B�6�H�������'Eqz����p��N��Ubx��/�
H!�������|���a	|�-)o��+�r"��w�}H�.�)����E����$x��4��bw�=�M�#�v��SI���������KN���M�LC}=>��;>�����dR*I��rw�2�'�M)�x�-��������z�c�������7�����+U=���gO�rj�PIL-(;|�6>�FY�-��q����;,��Z�A{�Z����
d��n/�_B6k�v@aaL��!_k���':�������y��.�j>yuv�����#�n��W���OM�T�5��
`�Q��h�U���@�
�~
(M^��.}��r��_�x���%�0�����7�gt�y~��a�`�`6[���?���,^�<�'��u�����DNm"���BQ<�l����4-'���[���-A�z�TY^l������h���1 5��{���9��N��&��E��"�Mu��rHO���bu���jD��D�.���f5[�7
�q������<��r��/�([N��*��f���H�h�+F�d�)��)w���)t�����\�ln>�3�Y�]�S�1�������R�=�����MLoz�h{�c��A������v���\�����s�C�0C�^�q������=�AH���8���U(@��y/���iKD�{�����L��S�#�d�{�dx��3B�M���?�g�	4@wL���J�+�t��e��\zO��`#X$I�+��bo�5�^!<P���a���b#��[���e`e~�����}~IGsz��Y-nM�[��������w�V����f��rZ���<�.�I<��Vc�W����v�[Z����b���&��SG�����_���r��4�yCY<Y���}/&����k�[��W��6�8��o��|���sz9�`����.���4��L�c��>~A��!B�`���s��_[8���_��ES/�[�&�wm�K�L0Z����������p�L�7M�rhHC):|@U9&e#T_����x��O3r�����7-1{b��vX�{?�LxI������
F��L�Q�|�P}*n����q��X3�� �3���	Ee,�����o�n���o|��5a�(��5�7,�U�@G����rA+~8]����p�fg���i�����+=���M���qp� 
��)�;��l<�8���a/��������������_�� ?���(x4A1���_�r.c�R1��ZJ(��EG�j*�UA���2����'R�C�����/���X�=3�E�,����'�t�����w~g�<sbM����R@��D-1�l�O�y�d���)8�A����$��#�!�cy��P�8��T��w Y�F�l���(R��n��������D���Ir�H���;�#0�3\#�}_�������Co��A$^h&(�x���=
����'Km#���Ge]Av�_ [�g��J�� 4�������l6�-!�v��W�J���#%��N$���W{
&=5��;�9;@@fU�������kvnx�)X�E�HdpP��"������)�����RR��q�u����u����d1��Na��l��w���).�
L�C�5��'��-�
���V���iE}yN����~o�0p�ta��'"����>Y����=+Pg`\<�o�H}�ge�}����&�)��`l��j�nFc�I��B�t�
w�,�5�
m��!���<��):���K���Y���5QWj���
�~{�
`�D����wbH��N��H������R���V`q����G�o���p�(�0�#@�!Yz��	8M�4d]<���B��As���f/5x�*�f���\�k]W$�T�<���/�\�v]��^�����;�����3�",>Z@��'L��:���M�8"m�b�p`6�h�QX/���?(�*�U�b�!��`�`.�Eb���3X��<�H�gS��LG	&�R��V��m�������� c�����3.tP�)��!�Ao��di����������D�n�b3?�s�8)
�J�P8�*U����L�ND><	9w��}Qp)e��8+��(�Dzi��)�x��5��5@:-��V.�[��F.piIO�8cH�r��'Lv�xD���nd�g���Q�4�X�	��|D�\��~�M'����JY������w�*XjT�4���p%@�[������M��Cf��5�������0$k
0�'�k����Lq�A3�U(�kH���>�!�����)���,u�����\Q����:e��d
��+��'
M�L4.���������|CX�1�Q�J�1�	59���1�#d��s@���������)�,P�|�8����9�+\�o�����d<L��B��{�`UL�I2�|�����bk�,�T����=k[�K�����'�������@��+������=�G���f/���A��������{��e8�0�(�~�����������9�{>^��e�	�	6{=��7��H������2IG�B!�+Of��2���������!�.}�;d�O-M<y�J�y�]����C�����p��thR�7tr>�d~,�Lo3PR`��O��l����7z7�>�B�<����1�����"4�3
�6�$a�0�����\-
��s07*���������GOX���3H�����^4/(9P����������ZYc=��F�������h�8U�7,���sE`>JN����V����\#C�.K[�,h���|:;^�4��	��f_��GT-��f���6�&�>b�%n`V@N�}���&���VR[�*���p._���T�	Z
�N���Dc�s�������0���sF1g��l@�I)4%��@�	�
�?:�	�_`�P��@uD�O����JAZ�3�$j��&�DZ�;3LUim��K�,�_�/"M�>!d(�\J���v6�)vSa�G='�	�.������^NxV8j��';�����F��A��O�|X�Ec[�X����cs�%Xi�_b�@�,'��}��;�����4���)��i�X+x����?��aL�N�".1�F����Qg�i���5y�b�\��}�`�? &�o������
�$��8��onP�F���#Z'����.^�D=���F7r�L4�~il6y�0E ��/��������t��@�nP�+��$N|����d(@�^82���h�=��^/�X�&��&UO�5iP���U<�m�n�-p�����x�y�I����$�
@�`�:A��E��s�%��7B�'w9;t��=��������Oy8��J�Tx(�"0;�u��(�0M�#�cn�}�$O�x�HI� ����@�a�65K�?atm�/"=���G�}�d��K��3%��I����m�����8��E�]��Z�G+�@L?%�a�����`p`1O���"��A�c�/b�I��sc[#O�[Q��� �B
YJ��y���BY�n��E��nll�J����s-��:��C>R����O��'(�Zo�O[��e�����WU�P�]N :������W2�UA�c�O����������3�;���j�������[������I`3���
�2���^�+
�{�gZ�u$n#XF8���L���3��
�g���n�W1�&���:��!y�e3��B�"��E1i�5�����$V������`s�� �`yD���]�W�6����o�)=���J`TJ��H�� �:��a����e����b9���;�>Sn��Hp���/%�AU&��fs}Y��4V��B�F��"��}4r��q���F��^��e��`�qT�����
�[���b�I�2GQ82�KSsD��4��6�FX�)z���$������9�pf=��kn�6����(J����VB��mR�)����i�R�+,��f��e�qH�qIv!0�]���Z���a���X����&w�a�U��@�{���V�eBJU���1<I��6'~��\/A�L��g_�r,�8��_��z�S���;�
H��jxd���B"�-3j�z:2!v�%�~��*����xGO��� 
m_�]3_�V�Wt>X�<��j��O���\��"��2��j�c�~��
f�d������-��B�&Y�����4���"�&�������7y����)m�>}{qx�K=����X�l�������� ��F��>��-��js
N���N]F�8u��T���u�����rxZ��erXZu�����������N]�c/gmoaV^��<�{W~'��k��"��!Q������$�����L	F>&�pw�Y^�����?�3��-`���C8����b;a���H<jw[�~�����N)���i��2�P���>������*^A���~�@=_G���D�-?��VKR�'�f�m��XZ�Ng������U��T-�,����;�h������+���^1�=�C\U��l�q��B��mc��z�w��*�BE{�[z��$��Z4[.��s�G��1��J�k����������1��hoR��]l����v�k2�Q�UH�D���v���
�d|����8�u��A���kaL�GKP���������,o�Sy,�$�3�[�cg �
7�L�ssu������|�	��������*����!+��c����nN~�z;�Qw���BC������^�r��*��������!��]I��lV\<�b/����J�����W���+]{h�{�~/�_"�Q�3��G;=9���v�"C�g���(\,.Rw��/W1�`S���)��@z��b������,=�7��m����������0����?�����?��`[��?��u�����rB�
(�����]�����`P��o;�����n`+�f�l������E6����C��� �nT���h�S��V�
5@��;{�����>��s$�<r���x��.0|�;	�/��x�I@����vgN��$�s�*�n�t��2�c
P�{9Z;�2�`d��lNCq[o��eFVmlg���{z��dY�\�]������p����6����S[�"�f;�{��;����jWB���F��y��,���\q�9~�;_����$���wI�"�)��j����*'b�a�D|���|x�Fsq;�]t�������_���L�tt�=��SXO�%�����K=�-��gF���j���:��������p�U�%��y@����k�k���k�yi6�h��~���/��}��Yv�}O����|�G����]?�p/����U��
��tZ���n���|���U����j�.!�I���C�����6:�(�Eg���A��e=r3GG�l~�Cp��:���??|���|G��a��H�W�z��6e(8�(e(��5u�@���Ba|ON_�<?��n�������G���mE�-a��v����������x��N�x�B&�S� >{a���
���c�*�@{��e+���7Nq=BX
���oS$��#��S��������c�~�w6�m���w��\A�����Vw����2G)���u�����O����b*=X�������J��g�%^�fz�.\���x����v2��Ia9g�E�l����"�� �k��LA�a����;���K�E�JO�x1GW�>[�5+�aXd0q:�g����x5%����]6�[8xF�N�s�����aoQ��^(�����W����/��BI����;���x�����?��������&����p�����?�uztp�N���	�;�Eq���3�@�O��~a�3\�'��������7��T}wrx@���Q��f�������c�{~�@�7�{�8�{r������J�������sl>A�����5�������_��t~�|t|���-���o��5��;���n�s�`���I�kn�~�y�5;�6�S���I�&����{��~(��,��D������p��x8
�������iN�LL�}.���R$B���h�5��F|X�@���5��
A��e�
�8��W�5�S���7kck���h&:�1(�c�D�1}�#X��?��n �j�� ����d�_j�*p�����e�����u_���(�3I@B�����&g���������VQ��M�������O��x��`V	������gR6l�;/�6��y�O��s���uZ8�"�|C����q�}���=<h�r�������J���]����m�����e�����r�=P^wD,��S�����K5}�����Q�z��l)J_j��P��t���E{��`����?w���iPy�T,�;w�ZQ2�Wxj�F���C����8��"�O�<�=@�����^qJ~�����������0�m�h���T�3��[�:R��������c���3|C/�-�`/���d�*t`��?��)J��3m�GGqt�������2��!7�����~-��7,G#r���E������y50v����
0r
�re��[;�mR,��z�v����*��?u^(},�����o.~y��a�}�/�+�lq>d����GGFR��b�����_A�a������n������d,��m��N�U�G����,@
�1S�vS��S-�`���R�/0�\qf��n���d�����l����)���)(l^��#or~�1��������P�������w%��4l�t%���J�w������){��A<����nE/�/=p��O��D�L<��f����A���H[.�Z�"�z<<�@��B�MD�����oO���7��.�sm�Ph�r]�M5pE�{[����M�1D�U���Tv
�u�����fP��^]�����q����-�$m�#1WO�,�sD*�v���L��;�fc\
�I<����y�jZ�?������jO��;Jv���E�z��JZ�I���uQ��5�f�����[�}Q|O���2��`9���3�5@�@���W�����#����>������EC*�n*(x�_7���a�/�&��%�s�)��n"�r�s.����:Y����3c����t�����V>��^��)��!���y$����������.XU0'M��c���9���0j��A^`rKq�0�����r)�2��c��/����g�L"�O�D�:��IP��N���P'�����l�c*3u�qJ��b
��B�DF����@�Yz����Cz��r����:`�w5N���&6����K�������?M�	q}�h��Jtq6{��o6�Q3*��(l���O10�3N��OnOx@��R<��hI��~7E�����5n�J��G����4��C*�<��1���q9CU�@�|!W�7Z������5)M[���-UB��kJ5�;"I^k���m����KQa0��{{��g�t�J�n�"������xAhh^��������������y��cT�+7���%������_0{��9�0hv �qZc���S�'O>j;��A����%�Vd��O������U�l�f�������{��gH��f��X����
�g�+�[A���}�����(���|�)���h T>�!{�REQ*�������*�{=�Sd��"8_�m��b�uF�6�D�#��,��O�|��d��bhr��$����pnw� 7m�j���G;�TA�d��VK���:�u��C���(��D�4r�3\�;iJ4��eS��`��.6���W���N~�;>:�2����������������6�o�*���b4-�MLQ������ �����(#>Ou(|�c4W����������xs����I4(����� �
����'v�6�u�Lm�}�
��A�m]�hO&�B��Z,g�d3�3��v���b�zJ��l�n�El��NFJ��qL�e���}��N1��"���X�M��/��6I���ZAHP��[jG����>F��|H�N�O��B�R���������y��� �tO���M�������kB�t��/���T����o��!w0����5��;�����u�]�kE*4�T����A��}O�S�%`�Og����C���%�~�[����u�_�i���X��4�W�s������Q�1��.c����^7c6�$�mF�Rr����(���=
�-YDJ�tQX�T�������
��J���'>9}wrzt��`��Q��G�+��n�H�]����_@�z�.�?=<����~s|�tzh����/�`f#y��&���<�z��N�{FN�<O���!�;�(]��k��g����9�J��q�D��@x�o�#i�/���L` ��f�O��dN0�0��;��D/{px_I��4�H�Th
X�����"����(�����������FIn�G���8i�K�[�j:��Xn��y��4l�����<@P�������!s�h�2G��^��	�I/\t1y~nw��E�!�E�_��s��n��E�4W%��RSQI)�w�x�w#/����x$ds�H���/6'���!��2�
�G������������f,`C6���f����7
�u^q�^����k���c�f9������[1����/���5Er�@��v�l���A��T#�~�k�Vk{����;�^+E���?V�aE'�QI�W5}}m���+��e�\2n_�*r�QAd��Z)����JqV$�u����
��dLI{��'������u�=�8���M����(D�B��99���5�r�zO	l�����<���N��oy��z7�p������zT���A��]��a/@o��8��R:��G�4���2�	�+\^��y:[`�+:o"�{kz�����1P���I�����z������E����%�&�L;��Qua�������8Gs���/��s4��"\
<#K�A�*�W����Z��v'�j?re���1#x����#�R+��W�v�2�?���<je~�|��i�� ���Rr�G�Va����U�y��K��W�w�.���D��`���1��t�o-|$������]���iP��A#d��{8������E`���#�q(��$5\��/�q/�%����+�����y@RkU����$���0�[QG�������_�D&KP�`z��|��	��W����7I<�o���x	O�k����a�2��&������=5�U�uP(��z���4�F��#>�~3���|��Q�<�^��/'.����\��'�~���12�W	����)������y
��p����Q��\: �R�U�x:�s�`�Y�4�"�wi:O�4Y"���Y�������)F��^�� �b�����	�L���q������il�l���q����������Ul�5��	
D�=�3����I��
Q�	t:.��w�o��z��c�^������TQ_�2_z/�H���]�����g	2}���ng�^H�|�;]bj�t����uC_"�Sr�wK	��qLG�x��.]e���H*O��Mmnnj��3���S�c2]3Bn����e��+�����WC����mY�����L2�e������!��@I���LK��d�E��/
�q�8H8r�e�����Hp�����\`;���!\W��/n�z>�
�w�5���$����
���:~:��-0��c|��_^�������G't��^\������%�4�OC�J���}4q����3��K�����{�y+M�E>�(�i.0�>�	��+���8=8�E�`��9�w����KN��5����1l(��U�!�Td����a+_��|>c�Z�Z����oJbE)���\'z+�x�J�hun����jG|S��I�~��p4mN�����u�����Pz'���2w���2��'<$	<$
��
�J�n7��n|6�n��x�nM���s�j����)qc5J�x,%�dt�'lx���d��f�D]���( U�n;jc=���Z����z�M�)$8{,)N&�5w����EA�?�'�:�l�jNJ���y2U�G2��%JC��u���F�!N����<?O�����>��G7��^�z��P�6�87���U�8������W��?>�$������x����a}�L�k��hv�����r�M1C��K��(���O"��������4/�������������#L��a����W�u���-���,Z�F�.�u98K&I���z�o����<������}O��W1��;R}��5�/���0���/�B�Bk�]��V���
0�4�uv�������� ��T��Y���(�
�����/���xD���AkCq�9Ptu$v��&B�{q��d#2��������<�W�6���oUwS��q�O	���
mo�jV�������y���.���y��^�x�E
���<�(�,X���an)���.Q���1����4�t�]n*���q��&�@��h=�y�P����
��e����uq��.q��[*jW��}/�h��'�]�N����!�W���E��_�M���
�."�����K��F
�:7|H�9�z����F���Y�����5s
Y��X!��sTF�9���+6`neY�ms|���2l7S�6/���>?���x��4o��p��=�B�����y��U����q��x���������J+]a3$h`���y<^<�/'	}�*rF�����D�]��e� �����DQ��y�y�`+joKU��cy|v
[�
+K�8����'�q��i�C���7�]z;���tQ:��P�&��O�6W
_
+
�R��y&uW
�r��fAc>Ng���t����i��v���l��2`�f��\!Tt��������{�hG����������42i��AqZ�{I����pex�����mu�Qo�'���7x����lucc&�������%��w��I��h���B����B�C����}+*�:J�� �\��c%�h�JS�g����f�_(:�������:�+Khd�6��]|8��<�������L�u~�^y�>.4���)�<���}}xrqO��2��mC��8n�����jY/h]���
��%��1�n�����
Vu�a����b����d��W;�����r@�cv��
�h����D��'Oxl
&+����Nf��l:U����gV����\")����������a2KcYDo�}4K���&���q����Q�D����G�'�c)NhO��aw��<Q��J������~_F`$�z�����H�bk��u9��#Q<�,R����V�����A��N����N8�����^������������jyFD��u
��;T�&����E��mj�\����<����|HF5�iypuwt�x�^�j�Po���zc�?�W��FIa����������I�IU�����Z�L�����]5E����
����n���'oE���P��5���ev�!�h�cc�-;�}]z�>�d5�)�5�Q��5t�%BR��x��khT����.\O����� P�h�&=8<�?k>��������t8*��3��������8tzt�ow��tR%�k4��:9���z��V��]��>��NK=���X"��A�P)��<.fOK�+�I���4I���w��z
�k��������w��S��`�����F0�IC���S� ������(���C��������^n+t��������w���sc9�R�����#�{_��O�w��p�Q@��eu�����E��"Z��������n���cx�-_�/(Hy|����]dS�����w�R��9+.�����%����=h��i����2��-&�,�H
2�9dW�����tx0NG�3t�P�P<�`S�J�0�TBQ���un(��ts�EV
����n��^�!�����}�*bo��'��[������}/
�%����<���mo�vE�J_| ���v�������e�;x��X!����\2������/��MF��l��`��0�q���IB�(4/�Z��0��uUem�a��[l
�c#��"��bXEw��w��p*j��u�����i�t�DO2��~�q��Y����w��s�]%�/A���;=�M��@����V7�j�%�j
���0��{CDl�a5��#��
?i[�Yo�upRP��7:t_�1��
��s�6DL��6������6:�<���l�k��j�@YF��@Wj<��Q�1>=�t��=�RHh����D66����pW�%A���6>^��%�g�dz��QMx������.	���d�B)�`����8�["�7�0]`,��I�1A��������I�Ck�x��.^������������ah:x@'��<�����^��q�.7GUX/	��d�D����5+ �����pr1����`�����Mu#����:g�I�|n��8�pt|��8 "�S`m<9�����+��#Z������$�dG_��)�2v�+�kj� 39y��9��h9�.f[cx�������n�-�'�����&V3��@��4'j$�B��HaWi2�0��}k�T����z��j���|q���p�;Iv`��Z�0�,�g�q�:�S)Wu��9�a7�O�S]l(����->7�a���D��P�������%���� �q�&n�����>7�:Oh����{vvxr��N�������#�����0�	|K��{�uQ�K�PX�Hy9�z�;����M�(6��c,�4��c�X�3�f���1����E��}q����3�x���[&`�<��Y���y����$�"�UAL�d�L�<,+�������	��]���m6�7�S�-�-�U��L����I����;Hx\�Q#s�'���(1��p����-O3��D���,C*,tafh:^��i�8�7J��Z��W��S<�����}�r

���
�5K�_[tHl����k�}U/�[Y����:��^g��-�����
�'�c����Or1�)�o"�x�,0�+}�]�NR�{�3Z�1�9�����s�e�������CE��B�XvjgcT��-x�/���\�9���^7m�����>�8��v������������� E�0/�}D���������]��w~�eC������3����������AO��	����-?}�G������)���-/
��x�6�A��<"�24�n�n�����V�u�<h�qw�F������08�����w��p������y�9�}O�7�1o�	���h�����\U�6�����u��������0��E�O���0��`<�J��h�H���'o���S�&��;��	�����85�r�4P`u����	�jy�'MO^�q-]�Zj2r�0��A�@�O�^�!:����x�������]�,P�o���CNu�4>cO�������������P�����b��16dG�B���GX�e9�v����NXllEvG�������� �?��4��J3�~�Z�Bk�j��=�����C���S-b��h����t����,����:.0�^}{��g��,�b� L����J�ns�J���+���2�;X��IV�brPm���v
��������5�:����Q�^�q_gT#��\m����O���#��T���������a�/�������[b��v�A��(�����_H�[����a����5&�2&���,�;����y�����fS���=�qu����C����������#�������B!,���B��l2��z3�A�<��x�nl���=���L8Z���3|7B_i�u���5�Q��z5��NC��a���,n@1��8f8�{	�/�l�l#<E����"�Y��`�DZR���Nm��##c9��A��6C����b�e��N��R�h4�{��OD
��c���LN����cb���� ��E�$���,�������C�����i��b��h�L�g�hk�������o@z~����H+}*��3��p_Y
t}��ZH��V��Bt% ��������j�v���V�(@<R����������ZNUB#
��h�`�-����]�{J�h�#��D��8l��A�70�F�"���������b1?��� 
����9�tm'=E��"�����{^[u���@���&pk�mm	zt��'�T�S��oO.\$���?��i6M��wt4Es�tN%�N����fX�/�*�������w��g������0*==;}wn��tO�N^
�a!?pa��I�d��W� ��F��5���&uX�q<���^������*��q�����f����7��X�k�0���O����e�J�l���*}g~����J8��`<���/h��w��+Z�S�dL�g6���xS�9;�?<@Y�9��C�m1�U6�dw/O��O�U��D{4J�a!��y��Rb�&jyF�������{�!��m����`��;P����+�����b�V�"��RO��dw���;2�4�v	h�.v@<��pM��7��]��7|�Q�b�u?}B���rm�PJZ�D��U�
_Q9�>��i���XIS���M��j��\���A� ���m?���/q���Z%�}K��O_�
�^���*����	{��,�I������G�a��"P��A���0�/�e�����5b�vA�V��E��nt�k�,s����[B.�B�@���H�	��.F8�r� �T�!��$&��s��yL>}�SjB��J�����hOE�|$�B����IIc�b�����4��08
�Y5��|1�l&����&�u����e���"�	:Y������1y�����lV�9����t����o�U#gH[��!��lhC�Ik��w��3�H�<�>�h�\-�>,�n��j����Q<C{�{���z fk	�C<��4O=�>��w{�4���tN�k7��_���~u��m�j��z�P�&Z�No��h�vV$;]A']Bw`,��/�
c�����g@5	B��`���O��$�s�#^O6
`tv)��e�^L,�����{g�2�>��W��r'jN�
pJv���e���Xv9@x��[?����%Et}���
����BGT�13�.$
�`J�MC�Dx��D<��E��(-{bw��qn~��3��R���:N�~T�e����39��j1���E�^��f�c��V���?ZQ�OxHU��3�2��8�dj������@������>���23�g7�B�����4�����C�i��v�dZ����������.i(�l ��V��v��xo2�M.��C�n�A���drSS2��!"�D!�Hz�h��o�r��W� �+��\g��K��3�����l�	*V�K�>�H�j�TQ�( �����6>mp����:BI�K�����	��C2_�����GS��e�\p6i�6�
���p���P'_Mh��?_}��^TG����-�u�vw�2��H�o�_>3�x��Y/2�Q~��2k&��N���l���d��}��7cz�\���������Q7@1�AEq�$�Is��b���e���6��V&�6�^T�<��Oz��|-�2�����[��^��wQOz��A�x$�nE��4��f��m���0�Mh/x�����3_����Do �>_\N������!�E�8�"i8��S��|���F&6�";�)��{��"�{�(�_�����|��TaE��W��XX������7MA�Y$c��5qgi���iOh�-0�`D�f�NU����V�;`�6�3O�;��T�
p�i�Od����W�/��f��1.�<�����T�}�/5v���alG�8�}~����8~T�;�:a���]�����B��?�q=�=z��!����w{G�E3|C�^��s�����h_�_��'o��K�G��^`P�suz|�NO���/��������| S��~�(��%o/�����g�{o��������~��q��P��8�;��������p��\�9='V�&�6�c��	��|������{@Wv��~��G|������W����a������?bgH��k=����I�{�����<�����u~�M����v�����������������vZ�>l��v�������C�gI�Z���N��h����i�;���0�S/�~�/��.�&��5��lv�����u��v��p���%L>��c�j�]�u�H6#?�W��E�,�&���v�b.�tA����Iz���i����yU�p4��!]	�ssa@�����x��l�$'�q2����B���&�������~R���%	]�6�u� ����]�Q�0�0���}��L�yn��I�q�9����J���d�}r��1��E4rA&F�,�5�E��>_$��z����8���{��K�#���Ot�vN�>ah6GoA��c�
Ja�iJh���uNB���b ZuEH�f�{���t� ����u���Q_�h�*��c��D��7^��Moxt�n������S�r��.�PX.]GNs���pY�u{\j~�������x}&�����Lc'7tWH���+VOm��>�^Bk�8c 4G�W�8��`*!��e�^,PR�����X�p�r�P��:������F���H��4�S�vN+K�G�P>u=}~��H#�
@��@�2�L�'��A#����r;K�<��t_��^���c!i���`���f��MPO�`��-=
8:8<��h��7�n������������������c_���6A�{�q��l��|�x-�&��m
+2�Ew8��9��8���oC�[�������5r7���42��_.S��iz7�L�zy��r�����z�A`P��[
4F���J|������)]�F��V�%������sy6��f�Y1�e(�����C����0��Y[�����|}�
��8{��r�Y���H2�#�k/d~9R�I�����3�������0u!��Sk����zn2)R�b�M�X�Z��Q�QJ>��c��M)�����ME��(r8J�%�����	K��������=�@
���%
�����_�Gz�8o�����'��������F!�D�e�Q����>t��^�KG��*����}r���Y����),�p.�?o��x��	�;-�Dz��(��pAuy��55���!��xr�n�L+"��q2I�
��0���cg��q�L�5<q�n�#jS?��5�������6={A(n}�����|9��$'�z�����*f2��
l�D{
�Pw"�H�d����o�b�:j�@�FQ��AFK}}��������!��T%�����D�*!t���B�Cy���j����4)�B�'FU�����}b��)y(2
��D�}�R�c��BW��d`�s$BD
���������=���3��V�UL��0�����<�t���,��n�w��?��0@;(�2�e��"}����D�����Y��j9��M���KAo?��c9�Y���4E�X_��c�a�.����W��x{�f%A_| x\:�l�� s_���6�L/#�&��#�b�x�!�:�	s�0"��p?U���)�(iR�_$rw��x5�����'�H���n�@V�<�$9��Z#�������}\����^��QsHT\Y�����!�7���h�3�4�!�,g5�5�pH;N/j<����B?��I
%�����4�m����$�?�uH�yR��3�gN��3��m��s���{:����|7��e�P1����,A� ��-E��6Q�g?�����>������� �a��fJ	�T���6���
�])� e�1xU�u���_��l.�K�����x�q9�E���8-*���������3�~���W� �����4fW�$i��Jo8BH�e�!�1=�[kT/��
�au��O��	R��
������&�����J5�&�/�R�Bm�u!���rh��]?rd��*���=HTl����A�������h6���o��d�:E�L���v��}\���nw�R&<���j�7�)�����W�T�"2��Wl���[���D5O�@pu8�������0���}�i���f���s6���qH�I�����@/��$���L�������6�9�Z\_G��H���It!R���W��Z��u�ZBuu��7&��j4.��{��<K�Q�����B���T����K��	�]P'S]�����B�3��QhS=�MJ��@�C�i-d����D�=�p���7��PZ)�Px.W�Uqq)k���>�f���'������w�bts������%n[�5�
��M��<���T
�V�^�Sxn�f�����4���
�xd�B�dc�9������V1���Q�0����I���9�4�>#�j�!��fN��,�6���|�.��U&��(_i���yr�����\M��@
�o�u���N�������NI&�p���b3�a�w�W2��������r�C�+j��]��EP����O^�3����%���yz��Z�4�� �jJK����mQ�'�S��.k���Y�D� ����Z�T���i-�z5D���~����w��'o(+in���<�:
!/[�����O�������w���&�{��[���q,<��6wM����m)�YD�AK��i�������h�D3�v��JZ��5!�m�����S{B`3n6T�]�������,.�93^
�l���\��=�������h 	O�,���2����<��t^@N�����t�wr���iWP�y���������h�an_�c7VC�x�������Sv9�Oi�UnYj����������W�I]����i���2]d���a��	���9���q���#����b\'|��Ff��q!��P�Nr��H�D,����[~
���+5�As�f/���h���xa��!	#���Y�[5�E p|�����|�L��T�l>'*�/�Ea�O�
:M�3����#�Ga������V
	��A�����?��\������fh�j�
+R���uK�V���4i������G:�����_���8����+�$=���?�����Lkf���$#��f�>/D�[�~h��+�z��{(.���z�&�s;�e�Q�� 9
)4Q�����JZaQi�i"�ne}��j��
����<�[��r��9\Z�#?��?V��%��Z.1�����h���"����K��oV*sV6����e������T���
?ZW��'��Lzy����ya��j�l������q2|T������#\�t���g�NH�s�N�@@����/n'$qSd��p��_���*�L�����jWL����`����&y���
�k�F�C����gB�(w��`��5�$�4�Z��Z���[��������n
XW�����w�M��R�\KF8R��4`"����\]��m��mr���
+�����G�y|+�'i��Z��*�Q��������i�*3�Z	��&�k�E������x/��=!R��|����hw�f4w.N2\���s��j4��q����a�����kzsXA��R+�:"[�#�G	wy�9�C�hW��f3mHfQ;����k���<���q9����������P�������k�#��++�J��z$��Z�Q���c�'���Gip����~l�&��mJn+�QZ�p�����q6N��tL��`A.�Pj��;�������;�5��T'
j�)��;'�:9X�"�<�zY��g���q#O��7�,*��!�������I���IL��c�'h�8��}����:��X��-8]� �?�-���dW�����9��<���	������4p�q/"K@ZHOA���c�KC~
�w�Kg7�����a�Lhl�-�ox_5��	vCj{fy�6'�*�f2]
�9�*{��a�!���5����bbo�����	���_�Vq�T^�U��\k���%9: �>bq���P�����Kwa}�Y��������P���+�T�������$��W���X�
��y%`��iF���3��j^��������+;�_���x��$��&7C6.��������yA�����L���� ��Ir*1u�$C�"m���F%�-h�$���#	}o���w��~�,p�\	$Rf���h# 8���90�_1����NP�Y���1�,��eySN���S�F��N�
Z�JGJ�p$'�H`����L�
�gk���N����Z|0N6�s�3;�E��.��=Z�y��gS�������Vbe"������c���J,X�]������E��������]�w�.�|U�<Kt�q.�F�"��x��w�pb'{K�7;5��9�M���MuN:�M�6��;e�v�����8]���la��\�s�����g�=%����Z��������14_� �:�����]����|��?���b9�m�dc����F�O����~��V��5���7Xt�G{���Nu�A��-�o�@�>a����X]m�l������xe����p8��?�|�~I�@j���UG�_������P?��r0�$`�~�W�tN�+�
�o.�.��)��7a~1&'wJJ}����O��.�lWX�B_���TX,��!`����^m�*Oqh%���g�u���Y��U^���a(k��AV�D�c�<<%�|�A�L��pa��k4tC����I]��.��B�K�c�xH�k(y�o.hz�:bw�2�
?0�����Wh��=u���7O1CX8~c�	�J1n����M��P��0-��<���Rj��Ojx��X�d�#���4]�+��$0|D*$�����<�����yf$q����g$�tT_���cH+������� *�#N�H��Q��C�}�&t,~�w�oS�c���,K�u�V���@m��p�&�h���>�bS�,Ji@�8�.�~#�$���O����uG�Y�W��s.�U��k
�9��L}�D��h�(���+h������l�R�L/��f�T����n�M;/N���������&��#���ph����![iYY�����Q;�o�
*N"w���f���v��#}���%^�q��4���`}j�!�U�2M�'BK�o_ #�c�&D�{�g.4�@���<�%+��U�DB�O�����KU@MQ�2���k�M���7�����q	��A�&t#��%Xi�y�������{��g��7P���T���{�~�wV��������S�0s�Q$&��5$�\�����W�<B�*���B=����>�>�e�T�a"���AFk�B�=����@'��}�9\Q�h���+���UpB�����L��{G�T)�yLc�zeC��fuP%
�a�-'c �|K5��Z��RJ�����/!�����6G�{�W�*��fK}��k����&��m
��������HmJa�0���{d�|�����4q]�D"c��V�"C�/)�o����i�fX�H���9�>GX&'3� �������n5�.Ly;��-<$��q�������V�E�J����(��^�%�c�U�Y���YQ8��	���>Y4ds�~��nla�o�����s���\�yQ��}����������Z����#�9�@R�Us�����5E���x���r)�H��XhS{�z���"�����L���T�5�)��WA����b��-O�D��A���\�.���j�x��w3�B�aT2�(��{^4�����4)��e���0x�W����c�!��H��f��������N:�G��t1����+��0n���5�����":��brj��,����:�;��mN��,�v��U`;Z��S�<���"h����Z��U�����c�:G4lz�1|7I'�E$��2����['�3`3jW��a�O��H��_Y�����+��f��76b�`
2y������G���������\9>�x�a���BC����"b�%��\'E���` 7s:.lp���D�KT��V���ni�DmS�|{�I�G����V�!��'�k���x���t���bxp�r�����������}XW������2�����@��y����O��O/�U���1_0,��s��������������T(��6n`�SUX&^z�o��3G�ku�!���&��^7B<&��z��fM)�D�h�C���X��<��A��@fkd���P�M�L����p�5���D:bf)�!���
���������CC[��|���O�7/*�KMk�Qeo�k��2H�7��t�����x'
���"J{h��~B��0����E���
j�M^7C����n*�����P����(f�^/Zl���������'�����D����_��nd�qe7��#�� E��	hi�c��9���H��y|��rdW����94]�E���zK��q������B*(�@������u(���]�g����M�t���O"1����=��
�f��u�'UD�dA�������E�6J��92`-�D���//����9�;{uNg����
���|����'��'��][��*��to4aN��Gf5��2r����6c��uy����s��e�b�d����I%�"��6�����Z��0fg����b�fD�
3���s<�^K��+�tX�[7��I���O�uP��7#�X����B��	N�hwk3�\/�3�K��#�E�DqW���Z�!Iw��}��B�=|wF4}�<{wl�M��L_���z��F#/����R�t��S���4�5���!��25B*5&�����2=������<��\��	�����E�,�k�����"\����(�
'��zq��s���p���X�j�^%0��72m�x}��qA���D3{���1NF����&=�LT ����[{'���1^�w�'��3�n��NND4k���dd.(�&	�d�W�egs|�h�p��	�����
=�x>�9�������������ia:�D��hsGF���)^���AG�����Ss���t�L�������Y�q��YA�������������R�S���<@�������zuxq~q�v��u� ;�iF4�MY�6w�Z,��q����CxF�J!��v{4n�KW����!J�o/��9��|��:������4k��a2�gsW6"Pa�)XL��1�%��j��?k<U7�p@~�L\���������"0�t�S"p~��D�E3E�w������$����j��[��`�C��|(�c*:I���Tdxth��M�9`�
�)�H�	��&�hV8q�)B�S/[�L���#�<����$�
J�]�[�J�n���x���"�[:�6%��>�.�e<CP�,�$q��Yq%���@��EZ>��e��.����S"�����`�h��j
��:hQ�6ho4�xt�x�a�<#�����]XD����?��R��<�����[�R�R:�����^������)��M1�HL`Z5W���I���|��|Q���r^�*<.�m��H}k!�k��>E�*�3K�r�<-�6�N:��Cr��tt�t�O�b�(u�X�v%����_���#��	[��u)���[�1�d����l@�o�)�RZE���!�yyp�r>���h�z�/$��%1���
�T<���
LP�A	�1��0����o|�����d�?�#��f�e��R�$��|�8���
���m��{�8�x���bC������9m���)P�T���2�N5����4��wgf3{��CM$,�1�}������~��-n�4��d4��05s����@�0����c|n�&2�����]S"�h��f1�1�����%3���� ���t�!�N��QG���	�"CU@=��<@���5�+_���wr����+*��Kd�d�����e�Y��{CxC��n���P���p��&�y!MY�E����B��ofX�y�����~���@�8n��g�����Cpb
_��e��c~��x*����-�
��|j�#�[[�?���"����TP��@(VQ���EG�Y����_����A+�!�e� ����#���(����&�
�
P�O0�D_�tT��X�&�����	=�c������;���
������?��ZrM������@�!�D���~���������}����.��c(�J�W'�(]��x�,s
�0��_?��������m9z�1��B���,��L}���������8���3�*������b#��;�L����M8� ��1�Ah�|�Q��nB3�M�}��"|M����=����HF��b���A�|2	
�r��QzluC�����S��r�8)DA� ��8��Y��8�S�|�	B�#��y0s$��
��V�l����(4��w�mR�
M�Sr=u���r	��MLnd���.�+��c��N�Ow,� R5����;��RX{�Y��g��-����$�^��5R����^U�G�'4�S!+n�gKI<\B��R�#�
c��hp����T2b�5�2��6@v�	�yV��b�������ff��v����q������<�����Z�9>� X3s`?/J�;/����|�Z��_�W�`�.C����q2"�N5�lc4��iW%�t��e\�q�� ����O,��0�%bj�5��"��y�8�t�\0�O�i�����6~�;E��[T9�����p&��\�����n����+��DMt��<v��Ni���I~��do�l�����?iXXU���)C�P�a��><��������O�@�H�	�
S>�*x��w����fC$1���i��XH�	��>��O$@���7s�����G�g	�
�9�%�DL�v~�������y/M�=��M<����b$lF�I�p��b�>���>.^��f�z=N��*�nci)�e$�(@���p�~P�o��O<�E�L�����j�������z�[=�������C���2���IaHeu�Z��d���
a;�0��*q� +8�p�-�KW�^_���J,a��8nCw�~ m]��O�R%�;Dw�^x=?c��.�'9�a�d�=`���,��!��2�x�5l�/:�)�7H�����9�OY�e��w����
;��aE2����i������W�hI|^�v�;���[��h`cS16=����.�k,�aH?!�#/0Z
��	���C6�����[����A����g�W;`����;��I����������LD|�?hr#�������Q6)��W7�l���9s�� �����z(������|��6^�SJ(\�o2��a�'F�vHa\I�����ZS�n�������'&3���y�0�_^?GInM����e?���<�KK�[s�~����.����u�g��M��	/�W ��O��u&�j9_�Ar4>��J��[8����8����>�������t��vv�u��=K/�OC/�2�	�M3��6�V���"4�^�+!���ny��;[\�2_V��d�Z�gj�*��I�����y����l�ucR�CmJ-sh��]�s��A&\���O)g;e��Swp�sKk}G���Q������D3p��]���Tj�ho>��R=U�f�Sq
PFi�������`h�Ln����z����f�`���W���u_���������eE��ov����^m����m����?�����X�}�-��E�zL�a�
�����l�p������e6Z6@��-�������7��h��:��V������WCQ�^�
����B����l�#Bg�x��c�7������E]������$���8t�\���{���6+�K��'9�����X3)���]S�~���;�`Q-�B��2,���w/���f�wC�VE����i���V-�%���9R�t��f�����[-��������������rg����4�*�
 ����?�S ������#m������6~��w�T����k�������x��^���9�*uczzZ~���������U?8�S�3x�iV�n�`7`�T���N���AS���*}�h}�n����K��i���gj{|z�Y�&D����%lA���R=}Q�������@��"//����8�/8���n��n���9Ik�o�#�g������q<��>���(����1�k�@�o������B��K��':����\�����������y���W�uw�
�S�e��'�^�]����:A�1>(:_#TXDUT�+�k��h���6��&Z��7?�gd���3������s������\��
#2David Fetter
david@fetter.org
In reply to: H.Harada (#1)
Re: window function v03 against HEAD

On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

I've put up a git repository at
<http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary&gt;

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

#3Hitoshi Harada
umi.tanuki@gmail.com
In reply to: David Fetter (#2)
Re: window function v03 against HEAD

2008/7/29 David Fetter <david@fetter.org>:

On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

I've put up a git repository at
<http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary&gt;

Thanks a lot.
I have tried to get clone from the URL but it didn't work.

$ git-clone http://git.postgresql.org/git/~davidfetter/window_functions/.git
Initialized empty Git repository in /home/forcia/repo/window_functions/.git/
Getting alternates list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting pack list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting index for pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
Getting pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
which contains c13ba377a6e58a05b5d9e39e36674af42126d48d

here it stops and tells nothing. This occurs on both Linux and Windows clients.
I succeeded on getting git://git.postgresql.org/git/postgresql.git.

I am quite new to git so if you know something please point me out.

Regards,

--
Hitoshi Harada

#4David Fetter
david@fetter.org
In reply to: Hitoshi Harada (#3)
Re: window function v03 against HEAD

On Thu, Jul 31, 2008 at 02:12:26PM +0900, Hitoshi Harada wrote:

2008/7/29 David Fetter <david@fetter.org>:

On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

I've put up a git repository at
<http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary&gt;

Thanks a lot.
I have tried to get clone from the URL but it didn't work.

$ git-clone http://git.postgresql.org/git/~davidfetter/window_functions/.git
Initialized empty Git repository in /home/forcia/repo/window_functions/.git/
Getting alternates list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting pack list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting index for pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
Getting pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
which contains c13ba377a6e58a05b5d9e39e36674af42126d48d

here it stops and tells nothing. This occurs on both Linux and
Windows clients.

How long does it hang for?

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

#5Hitoshi Harada
umi.tanuki@gmail.com
In reply to: David Fetter (#4)
Re: window function v03 against HEAD

2008/7/31 David Fetter <david@fetter.org>:

On Thu, Jul 31, 2008 at 02:12:26PM +0900, Hitoshi Harada wrote:

2008/7/29 David Fetter <david@fetter.org>:

On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

I've put up a git repository at
<http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary&gt;

Thanks a lot.
I have tried to get clone from the URL but it didn't work.

$ git-clone http://git.postgresql.org/git/~davidfetter/window_functions/.git
Initialized empty Git repository in /home/forcia/repo/window_functions/.git/
Getting alternates list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting pack list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting index for pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
Getting pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
which contains c13ba377a6e58a05b5d9e39e36674af42126d48d

here it stops and tells nothing. This occurs on both Linux and
Windows clients.

How long does it hang for?

Sorry, finally I got it. It took about an hour...

--
Hitoshi Harada

#6David Fetter
david@fetter.org
In reply to: Hitoshi Harada (#5)
Re: window function v03 against HEAD

On Thu, Jul 31, 2008 at 02:46:29PM +0900, Hitoshi Harada wrote:

2008/7/31 David Fetter <david@fetter.org>:

On Thu, Jul 31, 2008 at 02:12:26PM +0900, Hitoshi Harada wrote:

2008/7/29 David Fetter <david@fetter.org>:

On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

I've put up a git repository at
<http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary&gt;

Thanks a lot.
I have tried to get clone from the URL but it didn't work.

$ git-clone http://git.postgresql.org/git/~davidfetter/window_functions/.git
Initialized empty Git repository in /home/forcia/repo/window_functions/.git/
Getting alternates list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting pack list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting index for pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
Getting pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
which contains c13ba377a6e58a05b5d9e39e36674af42126d48d

here it stops and tells nothing. This occurs on both Linux and
Windows clients.

How long does it hang for?

Sorry, finally I got it. It took about an hour...

Sorry about that. Apparently, at least the way things are set up,
there's a *lot* of history you can rewind. Further changes should
move pretty quickly :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

#7Hitoshi Harada
umi.tanuki@gmail.com
In reply to: David Fetter (#6)
Re: window function v03 against HEAD

2008/7/31 David Fetter <david@fetter.org>:

On Thu, Jul 31, 2008 at 02:46:29PM +0900, Hitoshi Harada wrote:

2008/7/31 David Fetter <david@fetter.org>:

On Thu, Jul 31, 2008 at 02:12:26PM +0900, Hitoshi Harada wrote:

2008/7/29 David Fetter <david@fetter.org>:

On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:

I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
http://umitanuki.net/pgsql/wfv03/design.html

I've put up a git repository at
<http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary&gt;

Thanks a lot.
I have tried to get clone from the URL but it didn't work.

$ git-clone http://git.postgresql.org/git/~davidfetter/window_functions/.git
Initialized empty Git repository in /home/forcia/repo/window_functions/.git/
Getting alternates list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting pack list for
http://git.postgresql.org/git/~davidfetter/window_functions/.git
Getting index for pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
Getting pack 0c6bd5d85a8e0c5e0dee1a4e91b6c2691cb53555
which contains c13ba377a6e58a05b5d9e39e36674af42126d48d

here it stops and tells nothing. This occurs on both Linux and
Windows clients.

How long does it hang for?

Sorry, finally I got it. It took about an hour...

Sorry about that. Apparently, at least the way things are set up,
there's a *lot* of history you can rewind. Further changes should
move pretty quickly :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Thankfully, I succeeded to learn about git and started to use it on my
local. Then I read through the -hackers list about it but some points
are still not clear.

- Am I eligible to push git.postgresql.org/git/~davidfetter/window_functions?
- Or to get qualified do I need to claim?
- The repositories on git.postgresql.org need reviewing for new
push/pull or is it free to push there? How is the developing flow?

I just got some message when tried pushing:

error: Cannot access URL
http://git.postgresql.org/git/~davidfetter/window_functions/.git/,
return code 22
error: failed to push some refs to
'http://git.postgresql.org/git/~davidfetter/window_functions/.git&#39;

If possible, I would like an account to push for me.

Regards,

--
Hitoshi Harada

#8David Fetter
david@fetter.org
In reply to: Hitoshi Harada (#7)
Re: window function v03 against HEAD

On Thu, Jul 31, 2008 at 11:00:15PM +0900, Hitoshi Harada wrote:

2008/7/31 David Fetter <david@fetter.org>:

Sorry about that. Apparently, at least the way things are set up,
there's a *lot* of history you can rewind. Further changes should
move pretty quickly :)

Thankfully, I succeeded to learn about git and started to use it on
my local. Then I read through the -hackers list about it but some
points are still not clear.

I guess we'll all learn at once :)

- Am I eligible to push
git.postgresql.org/git/~davidfetter/window_functions?

You will be as soon as I can arrange it. I may move or re-create that
repository. Please send me a username and an RSA public key so I can
give you git-shell access.

- Or to get qualified do I need to claim?
- The repositories on git.postgresql.org need reviewing for new
push/pull or is it free to push there? How is the developing flow?

Working on that :)

I just got some message when tried pushing:

error: Cannot access URL
http://git.postgresql.org/git/~davidfetter/window_functions/.git/,
return code 22
error: failed to push some refs to
'http://git.postgresql.org/git/~davidfetter/window_functions/.git&#39;

If possible, I would like an account to push for me.

Right. I will start that this afternoon, PDT.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

#9Hitoshi Harada
umi.tanuki@gmail.com
In reply to: David Fetter (#8)
Re: window function v03 against HEAD

2008/8/1 David Fetter <david@fetter.org>:

You will be as soon as I can arrange it. I may move or re-create that
repository. Please send me a username and an RSA public key so I can
give you git-shell access.

Thank you for your consideration. But right now, I'm going to be off
for three days or so. As soon as coming back, I'll send it to you.

Regards,

--
Hitoshi Harada

#10David Fetter
david@fetter.org
In reply to: Hitoshi Harada (#9)
Re: window function v03 against HEAD

On Fri, Aug 01, 2008 at 02:13:52AM +0900, Hitoshi Harada wrote:

2008/8/1 David Fetter <david@fetter.org>:

You will be as soon as I can arrange it. I may move or re-create
that repository. Please send me a username and an RSA public key
so I can give you git-shell access.

Thank you for your consideration. But right now, I'm going to be off
for three days or so. As soon as coming back, I'll send it to you.

Enjoy your days off :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

#11Hitoshi Harada
umi.tanuki@gmail.com
In reply to: David Fetter (#8)
1 attachment(s)
Re: window function v03 against HEAD

2008/8/1 David Fetter <david@fetter.org>:

On Thu, Jul 31, 2008 at 11:00:15PM +0900, Hitoshi Harada wrote:

2008/7/31 David Fetter <david@fetter.org>:

Sorry about that. Apparently, at least the way things are set up,
there's a *lot* of history you can rewind. Further changes should
move pretty quickly :)

Thankfully, I succeeded to learn about git and started to use it on
my local. Then I read through the -hackers list about it but some
points are still not clear.

I guess we'll all learn at once :)

- Am I eligible to push
git.postgresql.org/git/~davidfetter/window_functions?

You will be as soon as I can arrange it. I may move or re-create that
repository. Please send me a username and an RSA public key so I can
give you git-shell access.

I've pushed my work into David's git hosting.
http://git.postgresql.org/?p=~davidfetter/window_functions/.git;a=summary

The DISTNCT fix which overlaps much of my patch were merged. And some
bugs were fixed while adding regression test for window functions.
Documantation is still out of order, because some points are
uncertain, including window function design. Up to now, I started to
think about new pg catalog for them (e.g. pg_wfunc).

If anyone is interested this patch please clone source tree from
git.postgresql.org and send me patch along with comments.

Regards,

--
Hitoshi Harada

Attachments:

window_functions.patch.tgzapplication/x-gzip; name=window_functions.patch.tgzDownload