summaryrefslogtreecommitdiff
path: root/doc/bug.template
diff options
context:
space:
mode:
authorTom Lane2019-11-11 19:39:55 +0000
committerTom Lane2019-11-11 19:39:55 +0000
commit84aad60b9cdade0a9d55f938bec92d788e2c54e9 (patch)
treed78a1eef8e2aee5605dde5927655d4210b2262e9 /doc/bug.template
parentc86e0dc37f7ff0fc1306d694d5e3e4b3ba95c6bc (diff)
Doc: fix ancient mistake, or at least obsolete info, in rules example.
The example of expansion of multiple views claimed that the resulting subquery nest would not get fully flattened because of an aggregate function. There's no aggregate in the example, though, only a user defined function confusingly named MIN(). In a modern server, the reason for the non-flattening is that MIN() is volatile, but I'm unsure whether that was true back when this text was written. Let's reduce the confusion level by using LEAST() instead (which we didn't have at the time this example was created). And then we can just say that the planner will flatten the sub-queries, so the rewrite system doesn't have to. Noted by Paul Jungwirth. This text is old enough to vote, so back-patch to all supported branches. Discussion: https://postgr.es/m/CA+renyXZFnmp9PcvX1EVR2dR=XG5e6E-AELr8AHCNZ8RYrpnPw@mail.gmail.com
Diffstat (limited to 'doc/bug.template')
0 files changed, 0 insertions, 0 deletions