Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

parse_clause.c

Blame
    • Tom Lane's avatar
      920c8261
      Improve the error message given for modifying a window with frame clause. · 920c8261
      Tom Lane authored
      For rather inscrutable reasons, SQL:2008 disallows copying-and-modifying a
      window definition that has any explicit framing clause.  The error message
      we gave for this only made sense if the referencing window definition
      itself contains an explicit framing clause, which it might well not.
      Moreover, in the context of an OVER clause it's not exactly obvious that
      "OVER (windowname)" implies copy-and-modify while "OVER windowname" does
      not.  This has led to multiple complaints, eg bug #5199 from Iliya
      Krapchatov.  Change to a hopefully more intelligible error message, and
      in the case where we have just "OVER (windowname)", add a HINT suggesting
      that omitting the parentheses will fix it.  Also improve the related
      documentation.  Back-patch to all supported branches.
      920c8261
      History
      Improve the error message given for modifying a window with frame clause.
      Tom Lane authored
      For rather inscrutable reasons, SQL:2008 disallows copying-and-modifying a
      window definition that has any explicit framing clause.  The error message
      we gave for this only made sense if the referencing window definition
      itself contains an explicit framing clause, which it might well not.
      Moreover, in the context of an OVER clause it's not exactly obvious that
      "OVER (windowname)" implies copy-and-modify while "OVER windowname" does
      not.  This has led to multiple complaints, eg bug #5199 from Iliya
      Krapchatov.  Change to a hopefully more intelligible error message, and
      in the case where we have just "OVER (windowname)", add a HINT suggesting
      that omitting the parentheses will fix it.  Also improve the related
      documentation.  Back-patch to all supported branches.