Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commita12c09a

Browse files
committed
Improve release note text about set-returning-function changes.
Paul Ramsey griped about this awhile ago, but I'd been holding fireon changing it until we settled what to do about the CASE/COALESCEissue.Discussion:https://postgr.es/m/CACowWR0AMyUt5fwtvuDqWyYNdp-hQJj9XqSxJR6YM9sKWov=_w@mail.gmail.com
1 parente90ceea commita12c09a

File tree

1 file changed

+16
-19
lines changed

1 file changed

+16
-19
lines changed

‎doc/src/sgml/release-10.sgml

Lines changed: 16 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -129,18 +129,29 @@
129129

130130
<listitem>
131131
<!--
132+
2017-01-16 [d43a619c6] Fix check_srf_call_placement() to handle VALUES cases co
132133
2017-01-18 [69f4b9c85] Move targetlist SRF handling from expression evaluation
133134
2017-01-18 [f13a1277a] Doc: improve documentation of new SRF-in-tlist behavior.
135+
2017-06-13 [0436f6bde] Disallow set-returning functions inside CASE or COALESCE
134136
-->
135137
<para>
136-
Allow <literal>COALESCE</> and <literal>CASE</> to return multiple
137-
rows when evaluating set-returning functions(Andres Freund).
138+
Change the implementation of set-returning functions appearing in
139+
a query's <literal>SELECT</> list(Andres Freund)
138140
</para>
139141

140142
<para>
141-
This also prevents conditionals like <literal>CASE</> from
142-
controlling the execution of set-returning functions because
143-
set-returning functions are now executed earlier.
143+
Set-returning functions are now evaluated before evaluation of scalar
144+
expressions in the <literal>SELECT</> list, much as though they had
145+
been placed in a <literal>LATERAL FROM</>-clause item. This allows
146+
saner semantics for cases where multiple set-returning functions are
147+
present. If they return different numbers of rows, the shorter results
148+
are extended to match the longest result by adding nulls. Previously
149+
the results were cycled until they all terminated at the same time,
150+
producing a number of rows equal to the least common multiple of the
151+
functions' periods. In addition, set-returning functions are now
152+
disallowed within <literal>CASE</> and <literal>COALESCE</> constructs.
153+
For more information
154+
see <xref linkend="xfunc-sql-functions-returning-set">.
144155
</para>
145156
</listitem>
146157

@@ -1701,20 +1712,6 @@
17011712
</para>
17021713
</listitem>
17031714

1704-
<listitem>
1705-
<!--
1706-
2017-01-16 [d43a619c6] Fix check_srf_call_placement() to handle VALUES cases co
1707-
-->
1708-
<para>
1709-
Fix <function>check_srf_call_placement()</> to handle
1710-
<command>VALUES</> cases correctly (Tom Lane)
1711-
</para>
1712-
1713-
<para>
1714-
NEED TEXT.
1715-
</para>
1716-
</listitem>
1717-
17181715
</itemizedlist>
17191716

17201717
</sect3>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp