duckdb-web icon indicating copy to clipboard operation
duckdb-web copied to clipboard

Issue found on page 'Star Expression' - contradiction on where COLUMNS may be used.

Open rpbouman opened this issue 7 months ago • 0 comments

In https://duckdb.org/docs/sql/expressions/star#columns-expression , it reads:

The COLUMNS expression can be used to execute the same expression on multiple columns. Like the * expression, it can only be used in the SELECT clause.

And then later, in the same section:

COLUMNS expressions can also be used in WHERE clauses. The conditions are applied to all columns and are combined using the logical AND operator.

"only in the SELECT clause" and "also in the WHERE clause" sounds like an obvious contradiction.

rpbouman avatar Jul 14 '24 17:07 rpbouman