2008/9/4 Erikj <er@xs4all.nl>:
> Dear Hitoshi,
>
> I noticed the folowing typo in the doc sgml:
>
> 'rownumber()', instead of 'row_number()' ( 2x )
>
> hth
>
> Erik Rijkers
>
>
>
> *** doc/src/sgml/func.sgml.orig 2008-09-03 17:20:28.130229027 +0200
> --- doc/src/sgml/func.sgml 2008-09-03 17:21:01.331907454 +0200
> ***************
> *** 10092,10100 ****
> <row>
> <entry>
> <indexterm>
> ! <primary>rownumber()</primary>
> </indexterm>
> ! <function>rownumber() OVER (ORDER BY <replaceable
> class="parameter">expression</replaceable>)</function>
> </entry>
> <entry>
> <type>bigint</type>
> --- 10092,10100 ----
> <row>
> <entry>
> <indexterm>
> ! <primary>row_number()</primary>
> </indexterm>
> ! <function>row_number() OVER (ORDER BY <replaceable
> class="parameter">expression</replaceable>)</function>
> </entry>
> <entry>
> <type>bigint</type>
>
Ah, thanks. It's my mistake. Both of SQL spec and my implementation in
pg_proc say it is row_number, not rownumber.
Regards,
--
Hitoshi Harada