On Tue, Mar 24, 2026 at 6:34 PM Yugo Nagata <[email protected]> wrote: > > Hi, > > I've attached a patch to adjust the error message for CREATE STATISTICS > to account for expressions. > > Previously, when attempting to create extended statistics on a single column, > the following error is raised. > > ERROR: extended statistics require at least 2 columns > > However, this message assumed only columns. In reality, an expression on a > single column is also allowed, so two columns are not necessarily required. > Thgis patch updates the message to: > > ERROR: extended statistics require at least 2 columns or an expression
I'm ambivalent about this. Instead of trying to document all the possible valid possibilities (which may get out of date again), maybe we can say that it's not allowed on a single column? -- John Naylor Amazon Web Services
