Results of 1 - 10 of about 11 for identifier (0.004 sec.)
- DuckDB_% Metadata Functions – DuckDB 13478
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...umn Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema_name The SQL name of the schema that contains the table obj...ect that defines this column. VARCHAR schema_oid Internal identifier of the schema object that contains the table of the column. BIGINT table_name The SQL name of the table that defines the c... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Full-Text Search Extension – DuckDB 10935
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...ARCHAR Qualified name of specified table, e.g., 'table_name' or 'main.table_name' input_id VARCHAR Column name of document identifier, e.g., 'document_identifier' input_values... VARCHAR Column names of the text fields to be indexed (vararg), e.g., 'text_f...eval macro is created that can be used to search the index. Name Type Description input_id VARCHAR Column name of document identifier, e.g., 'document_identifier' query_string VARCHAR The string to search the index for fields VARCHAR Comma-separarated list... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Keywords and Identifiers – DuckDB 10135
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / DuckDB's SQL Dialect Copy Markdown Keywords and Identifiers 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_keywords() ), e.g., SELECT 123 AS S... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- PostgreSQL Compatibility – DuckDB 8072
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...ue true 1 = 1.1 false false true = 'true' true true true = 1 error true 'true' = 1 error error Case Sensitivity for Quoted Identifiers PostgreSQL is case-insensitive. The way PostgreSQL achieves case insensitivity is by lowercasing unquoted identifiers wit...Le ( x INTEGER ); SELECT * FROM "MyTaBLe" ; ERROR: relation "MyTaBLe" does not exist PostgreSQL does not only treat quoted identifiers as case-sensitive, PostgreSQL treats all identifiers as case-sensitive, e.g., this also does not work: CREATE TABLE "Pres... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- JSON Processing Functions – DuckDB 7984
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...ement type VARCHAR json_type (function) of this element atom JSON json_value (function) of this element id UBIGINT Element identifier, numbered by parse order parent UBIGINT id of parent element fullkey VARCHAR JSON path to element path VARCHAR JSON path t...arent element json JSON (Virtual) The json parameter root TEXT (Virtual) The path parameter rowid BIGINT (Virtual) The row identifier These functions are analogous to SQLite's functions with the same name . Note that, because the json_each and json_tree fu... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Configuration – DuckDB 7930
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...a pivot statement UBIGINT 100000 prefer_range_joins Force use of range joins with mixed predicates BOOLEAN false preserve_identifier_case Whether or not to preserve the identifier case, instead of always lowercasing all non-quoted identifiers BOOLEAN true... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Pragmas – DuckDB 7930
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...; Information on DuckDB Version Show DuckDB version: PRAGMA version ; CALL pragma_version (); Platform platform returns an identifier for the platform the current DuckDB executable has been compiled for, e.g., osx_arm64 . The format of this identifier matc... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Utility Functions – DuckDB 7930
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...the expression. Expression can be a column, constant, or SQL expression. txid_current() Returns the current transaction's identifier, a BIGINT value. It will assign a new one if the current transaction does not have one already. typeof(expression) Returns.... Example stats(5) Result '[Min: 5, Max: 5][Has Null: false]' txid_current() Description Returns the current transaction's identifier, a BIGINT value. It will assign a new one if the current transaction does not have one already. Example txid_current() Res... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Schema – DuckDB 7823
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...g on different types by computing a self-join on the LDBC Comment table at scale factor 100 . The table has 64-bit integer identifiers used as the id attribute of each row. We perform the following join operation: SELECT count ( * ) AS count FROM Comment c...set, primary keys will only have a (small) positive effect on highly selective queries such as when filtering on a single identifier. Definining primary keys (or indexes) will not have an effect on join and aggregation operators. Bestpractice For best bul... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Constraints – DuckDB 7823
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ndexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions...Primary Key and Unique Constraint Primary key or unique constraints define a column, or set of columns, that are a unique identifier for a row in the table. The constraint enforces that the specified columns are unique within a table, i.e., that at most o... - https://man.mtool.work/duckdb/1.3/sql/constraints.html
DuckDB 1.3 Documentation / man.mtool.work