Results of 1 - 10 of about 27 for bound (0.005 sec.)
- Union Functions 12574
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...gle member UNION containing the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected tag of the union as an Enum . union.tag | Description | Do...e(tag := any) | Description | Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. | | Example | union_value(k := 'hello') | | Result | hello (of type UNION(k VARCHAR) ) | union_tag(union) |... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Run Queries 10895
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...f err != nil { log.Fatal(err) } n, _ := res.RowsAffected() log.Printf("inserted %d rows", n) Binding Parameters Values are bound to a statement's placeholders rather than formatted into the SQL string, which avoids SQL injection and lets DuckDB reuse...ta for the Appender, which is far faster for bulk inserts. Forcing a Parameter Type The client infers the DuckDB type of a bound value from its Go type. When that inference is not what you want, wrap the value with duckdb.Typed() to pin the DuckDB log...S), ) duckdb.Typed() is a scalar binding hint; DuckDB validates the value against the requested type when the parameter is bound. See Troubleshoot for the details of how the client maps time.Time to DuckDB's timestamp types. Prepared Statements db.Pre... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Comparisons 10895
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...AS separate_result; between_result separate_result true false For the expression BETWEEN x AND y , x is used as the lower bound and y is used as the upper bound. Therefore, if x > y , the result will always be false .... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Overview of DuckDB Internals 10615
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...QL statements in case the original query string contains multiple queries. Binder The binder converts all nodes into their bound equivalents. In the binder phase: The tables and columns are resolved using the catalog Types are resolved Aggregate/windo...w functions are extracted The following conversions happen: SQLStatement → BoundStatement QueryNode → BoundQueryNode TableRef → BoundStatement ParsedExpression → Expression Logical Planner The logical pl...anner creates LogicalOperator nodes from the bound statements. In this phase, the actual logical query tree is created. Optimizer After the logical planner has created the l... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Iceberg Functions 10352
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...stored in the manifests for every data file and column. Its columns include file_path , column_name , column_type , lower_bound , upper_bound , value_count , null_value_count and nan_value_count . SELECT * FROM iceberg_column_stats('data/iceberg/line...r partition field. Its columns include partition_field_name , partition_source_columns , partition_field_transform , lower_bound and upper_bound . SELECT * FROM iceberg_partition_stats(my_datalake.default.t); iceberg_load_table_response The iceberg_lo..., partition, record count, file size and column-level statistics ( column_sizes , value_counts , null_value_counts , lower_bounds , upper_bounds , readable_metrics , etc.). iceberg_manifests(source) allow_moved_paths , snapshot_from_id , snapshot_from... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Securing Quack with a Reverse Proxy 9512
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...ng # through nginx defeats the streaming and inflates memory. proxy_buffering off; } } On the Quack side, start the server bound to localhost (the default): {:.codebox-server} CALL quack_serve('quack:localhost'); Issue the certificate with certbot --n...y handles certificate issuance and renewal automatically. No certbot step is required. On the Quack side, start the server bound to localhost (the default): {:.codebox-server} CALL quack_serve('quack:localhost'); Clients connect over HTTPS automatical... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Run Queries 9233
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...rson ( id INTEGER PRIMARY KEY DEFAULT NEXTVAL('seq'), name TEXT NOT NULL, data BLOB );", )?; Binding Parameters Values are bound to a statement's placeholders rather than formatted into the SQL string. DuckDB uses positional ( ? ) and numbered ( ?1 ,..."SELECT $age >= 18 AND $name = 'Alice'", named_params! { "age": min_age, "name": name, }, |row| row.get(0), )?; Any value bound as a parameter implements the ToSql trait, and any value read out of a row implements FromSql . The crate provides both fo... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- SQL to/from JSON 8953
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...or now. json_serialize_plan(varchar, skip_default := boolean, format := boolean, optimize := boolean) Scalar Serialize the bound logical query plan of a set of semicolon-separated ( ; ) statements to JSON. If optimize is true , the optimized plan is s...e_sql('TOTALLY NOT VALID SQL')); Parser Error: Error parsing json: parser: syntax error at or near "VALID" Serializing the bound logical plan of a statement with json_serialize_plan : SELECT json_serialize_plan('SELECT 1 + 2', format := true); { "erro... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Struct Functions 8953
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...STRUCT as a list. struct_pack(name := any, ...) Create a STRUCT containing the argument values. The entry name will be the bound variable name. struct_position(struct, entry) Return the index of the entry within the STRUCT (1-based), or NULL if not fo...| struct_pack(name := any, ...) | Description | Create a STRUCT containing the argument values. The entry name will be the bound variable name. | | Example | struct_pack(i := 4, s := 'string') | | Result | {'i': 4, 's': string} | struct_position(struc... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Python Client API 8673
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...Run a SQL query. A statement that only reads returns a relation that runs the query each time it is read, parameter values bound at every run. Any other statement runs once, now, and gives a relation over what it returned. Statements before the last o...Run a SQL query. A statement that only reads returns a relation that runs the query each time it is read, parameter values bound at every run. Any other statement runs once, now, and gives a relation over what it returned. Statements before the last o...Run a SQL query. A statement that only reads returns a relation that runs the query each time it is read, parameter values bound at every run. Any other statement runs once, now, and gives a relation over what it returned. Statements before the last o... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
DuckDB 2.0 Documentation / man.mtool.work