Search Result: partcode - DuckDB 2.0 全文検索

Loops 9414: Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0.. ... multiple statements can be part of a loop) endloop Similarly, foreach can be used to iterate over a set of values. foreach partcode millennium century decade year quarter month day hour minute second millisecond microsecond epoch query III SELECT i, date ... _part('${partcode}', i) AS p, date_part(['${partcode}'], i) AS st FROM intervals WHERE p <> st['${partcode}']; ---- endloop foreach also has ...; https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work