Results of 1 - 4 of about 4 for foreach (0.001 sec.)
- Loops 12279
- 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..
...OM integers WHERE i = ${i}; ---- 1 # end the loop (note that 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...part('${partcode}', i) AS p, date_part(['${partcode}'], i) AS st FROM intervals WHERE p <> st['${partcode}']; ---- endloop foreach also has a number of preset combinations that should be used when required. In this manner, when new combinations are adde... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- PHP Client (PDO) 9079
- The PHP DuckDB PDO extension is a tertiary client and is maintained by a third-party. To use pdo_duckdb , follow the instructions below . The latest version of pdo_duckdb supports DuckDB 2.0.0. pdo_duckdb is a native DuckDB database driver
...?', ['foo' => 'bar', 'baz' => 42]]); $db->exec("COPY (SELECT * FROM table1) TO '/tmp/table1.parquet' (COMPRESSION zstd)"); foreach ($db->query("SELECT * FROM '/tmp/table1.parquet'", PDO::FETCH_ASSOC) as $row) { print_r($row); } # Array # ( # [id] => 1 #...<?php $list = [ ['aaa', 'bbb', 'ccc'], ['123', '456', '789'], ['aaa', 'bbb', 'ccc'] ]; $fp = fopen('/tmp/test.csv', 'w'); foreach ($list as $fields) { fputcsv($fp, $fields, ',', '"', ''); } fclose($fp); $db = new PDO('duckdb::memory:'); $statement = $d... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php_pdo.html
- Benchmark Suite 8081
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...) times(m) cross join range(${keys}) keys(k) ); The argument parameters are expanded in the query, similar to the way that foreach values are expanded in unit tests. Note that we can issue multiple SQL statements in the load section. Once the data is pr... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Write User Defined Functions 7489
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...hParameters(tsType, strType, dblType) .withReturnType(strType) .withVectorizedFunction((input, output) -> { input.stream().forEach(row -> { String value = input.vector(0).getLocalDateTime(row) + " | " + String.valueOf(input.vector(1).getString(row)).tri... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work