Results of 1 - 10 of about 12 for bare (0.001 sec.)
- SHOW, SHOW DATABASES, and SHOW SCHEMAS Statements 12593
- SHOW Statement The SHOW statement can also show the schema of a table, view or query, like DESCRIBE . As of DuckDB 2.0, this usage is deprecated and prints a warning; use DESCRIBE instead. New The following feature was introduced in DuckDB
...ing (use DESCRIBE for tables). DESCRIBE never resolves a setting. The show_behavior setting configures how SHOW resolves a bare identifier: 'auto' (default): describe a table if one exists, otherwise show the setting. 'table' : always describe a tabl... - https://man.mtool.work/duckdb/2.0/sql/statements/show.html
- Describe 11320
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...bl is deprecated and emits a warning. Use DESCRIBE tbl instead. The show_behavior setting controls whether SHOW resolves a bare identifier to a table or a setting. Describing a Query To view the schema of the result of a query, prepend DESCRIBE to a... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- Troubleshoot 9409
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...r TIMESTAMP_TZ , and scanning either type back returns an instant, because SQL types do not model a per-value time zone. A bare time.Time binds as TIMESTAMP_TZ by default. When a different timestamp type is required, for example binding against a TIM... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- SQL Quirks 9409
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...th (unlike the LIMIT clause). Implicit Conversion of Identifiers in Table Function Arguments DuckDB historically allowed a bare, unbound identifier to be used as a table function argument, implicitly converting it to a string literal. For example, gl... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Write User Defined Functions 8790
- Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a
...r connector.Close() duckdb.RegisterReplacementScan(connector, func(tableName string) (string, []any, error) { // Treat any bare table name as a Parquet file of that name. return "read_parquet", []any{tableName + ".parquet"}, nil }) db := sql.OpenDB(c... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
- Run Queries 8790
- 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
...not what you want, wrap the value with duckdb.Typed() to pin the DuckDB logical type . This matters most for timestamps: a bare time.Time binds as TIMESTAMP_TZ , so binding against a TIMESTAMP_NS column needs the hint: start := time.Date(2024, time.A... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Deploy 8790
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...shell.duckdb.org deployment transpiles the main library together with the shell code (the first approach above), while the bare-browser example shows a minimal setup. JS Worker Component This is distributed as a JavaScript file in three different fla... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Keywords and Identifiers 8790
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...st of such entries that are searched in order. Both options write to the same catalog search path, and each entry may be a bare schema or a ⟨catalog⟩.⟨schema⟩ pair. For a detailed description of how database and schema names are resolved, including t...S(Pi()) as CosineOfPi; SELECT cos(pi()) AS CosineOfPi; CosineOfPi -1.0 Case-Sensitivity of Identifiers Identifiers in DuckDB are always case-insensitive, similarly to PostgreSQL. However, unlike PostgreSQL (and some other major SQL implementations),... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Numeric Types 8154
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...IMAL(18,3) DECIMAL(10,0) DECIMAL(10,0) The NUMERIC alias accepts the same spellings and yields the same types. Note that a bare DECIMAL is not an unconstrained decimal type as it is in PostgreSQL and Oracle. DuckDB always binds it to the concrete typ... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Struct Data Type 7517
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...'frog', 'maybe': 'salamander', 'huh': 'dragon', 'no': 'toad'} } AS s; New As of DuckDB 2.0, STRUCT types may be empty. The bare type name STRUCT denotes an empty struct, so both NULL::STRUCT and CREATE TABLE t (s STRUCT) are valid, and struct_pack()... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
DuckDB 2.0 Documentation / man.mtool.work