diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 87a6ba8d10f..46d6db3cfe0 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -19594,17 +19594,17 @@ SELECT count(*) FROM sometable; <indexterm> <primary>lag</primary> </indexterm> - <function>lag</function> ( <parameter>value</parameter> <type>anyelement</type> + <function>lag</function> ( <parameter>value</parameter> <type>anycompatible</type> <optional>, <parameter>offset</parameter> <type>integer</type> - <optional>, <parameter>default</parameter> <type>anyelement</type> </optional></optional> ) - <returnvalue>anyelement</returnvalue> + <optional>, <parameter>default</parameter> <type>anycompatible</type> </optional></optional> ) + <returnvalue>anycompatible</returnvalue> </para> <para> Returns <parameter>value</parameter> evaluated at the row that is <parameter>offset</parameter> rows before the current row within the partition; if there is no such row, instead returns <parameter>default</parameter> - (which must be of the same type as + (which must be of a type compatible with <parameter>value</parameter>). Both <parameter>offset</parameter> and <parameter>default</parameter> are evaluated @@ -19619,17 +19619,17 @@ SELECT count(*) FROM sometable; <indexterm> <primary>lead</primary> </indexterm> - <function>lead</function> ( <parameter>value</parameter> <type>anyelement</type> + <function>lead</function> ( <parameter>value</parameter> <type>anycompatible</type> <optional>, <parameter>offset</parameter> <type>integer</type> - <optional>, <parameter>default</parameter> <type>anyelement</type> </optional></optional> ) - <returnvalue>anyelement</returnvalue> + <optional>, <parameter>default</parameter> <type>anycompatible</type> </optional></optional> ) + <returnvalue>anycompatible</returnvalue> </para> <para> Returns <parameter>value</parameter> evaluated at the row that is <parameter>offset</parameter> rows after the current row within the partition; if there is no such row, instead returns <parameter>default</parameter> - (which must be of the same type as + (which must be of a type compatible with <parameter>value</parameter>). Both <parameter>offset</parameter> and <parameter>default</parameter> are evaluated |