NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commit23ddcd7

committed

Docs: be explicit about datatype matching for lead/lag functions.

The default argument, if given, has to be of exactly the same datatypeas the first argument; but this was not stated in so many words, andthe error message you get about it might not lead your thought in theright direction. Per bug #13587 from Robert McGehee.A quick scan says that these are the only two built-in functions with twoanyelement arguments and no other polymorphic arguments. There are plentyof cases of, eg, anyarray and anyelement, but those seem less likely toconfuse. For instance this doesn't seem terribly hard to figure out:"function array_remove(integer[], numeric) does not exist". So I'vecontented myself with fixing these two cases.

1 parent7c57449 commit23ddcd7Copy full SHA for 23ddcd7

File tree

1 file changed

+10

-6

lines changed

doc/src/sgml
- func.sgml

1 file changed

+10

-6

lines changed

`‎doc/src/sgml/func.sgml`

Lines changed: 10 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -10603,9 +10603,9 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;`
`10603`	`10603`	`<primary>lag</primary>`
`10604`	`10604`	`</indexterm>`
`10605`	`10605`	`<function>`
`10606`		`- lag(<replaceable class="parameter">value</replaceable> <type>any</>`
	`10606`	`+ lag(<replaceable class="parameter">value</replaceable> <type>anyelement</>`
`10607`	`10607`	`[, <replaceable class="parameter">offset</replaceable> <type>integer</>`
`10608`		`- [, <replaceable class="parameter">default</replaceable> <type>any</> ]])`
	`10608`	`+ [, <replaceable class="parameter">default</replaceable> <type>anyelement</> ]])`
`10609`	`10609`	`</function>`
`10610`	`10610`	`</entry>`
`10611`	`10611`	`<entry>`
`@@ -10615,7 +10615,9 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;`
`10615`	`10615`	`returns <replaceable class="parameter">value</replaceable> evaluated at`
`10616`	`10616`	`the row that is <replaceable class="parameter">offset</replaceable>`
`10617`	`10617`	`rows before the current row within the partition; if there is no such`
`10618`		`- row, instead return <replaceable class="parameter">default</replaceable>.`
	`10618`	`+ row, instead return <replaceable class="parameter">default</replaceable>`
	`10619`	`+ (which must be of the same type as`
	`10620`	`+ <replaceable class="parameter">value</replaceable>).`
`10619`	`10621`	`Both <replaceable class="parameter">offset</replaceable> and`
`10620`	`10622`	`<replaceable class="parameter">default</replaceable> are evaluated`
`10621`	`10623`	`with respect to the current row. If omitted,`
`@@ -10630,9 +10632,9 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;`
`10630`	`10632`	`<primary>lead</primary>`
`10631`	`10633`	`</indexterm>`
`10632`	`10634`	`<function>`
`10633`		`- lead(<replaceable class="parameter">value</replaceable> <type>any</>`
	`10635`	`+ lead(<replaceable class="parameter">value</replaceable> <type>anyelement</>`
`10634`	`10636`	`[, <replaceable class="parameter">offset</replaceable> <type>integer</>`
`10635`		`- [, <replaceable class="parameter">default</replaceable> <type>any</> ]])`
	`10637`	`+ [, <replaceable class="parameter">default</replaceable> <type>anyelement</> ]])`
`10636`	`10638`	`</function>`
`10637`	`10639`	`</entry>`
`10638`	`10640`	`<entry>`
`@@ -10642,7 +10644,9 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;`
`10642`	`10644`	`returns <replaceable class="parameter">value</replaceable> evaluated at`
`10643`	`10645`	`the row that is <replaceable class="parameter">offset</replaceable>`
`10644`	`10646`	`rows after the current row within the partition; if there is no such`
`10645`		`- row, instead return <replaceable class="parameter">default</replaceable>.`
	`10647`	`+ row, instead return <replaceable class="parameter">default</replaceable>`
	`10648`	`+ (which must be of the same type as`
	`10649`	`+ <replaceable class="parameter">value</replaceable>).`
`10646`	`10650`	`Both <replaceable class="parameter">offset</replaceable> and`
`10647`	`10651`	`<replaceable class="parameter">default</replaceable> are evaluated`
`10648`	`10652`	`with respect to the current row. If omitted,`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit23ddcd7

File tree

1 file changed

1 file changed

`‎doc/src/sgml/func.sgml`

0 commit comments