Results of 1 - 7 of about 7 for presence (0.002 sec.)
- IN Operator 13304
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
....] (List) The IN operator works on lists according to the semantics used in Python. Unlike for the IN tuple operator , the presence of NULL values on the right hand side of the expression does not make a difference in the result: SELECT 'Math' IN ['CS',...ath', NULL]; false IN Map The IN operator works on maps according to the semantics used in Python, i.e., it checks for the presence of keys (not values): SELECT 'key1' IN MAP {'key1': 50, 'key2': 75}; true SELECT 'key3' IN MAP {'key1': 50, 'key2': 75}; f... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- Loops 9687
- 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..
... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- AWS Extension 8379
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...lows CREATE SECRET to succeed for credential_chain s with no available credentials. VALIDATION 'exists' validates only the presence of a credential, not its operational readiness . Thus, no attempt is made to convert into an access token, or perform a re... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Logging 8379
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...L enable_logging(storage = 'file', storage_path = 'path/to/store/logs'); -- omitting `storage = 'file'` -> is implied from presence of `storage_config` CALL enable_logging(storage_config = {'path': 'path/to/store/logs'});... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Spatial Functions 8051
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...nimum Y coordinate of a geometry ST_Z Returns the Z coordinate of a point geometry ST_ZMFlag Returns a flag indicating the presence of Z and M values in the input geometry. ST_ZMax Returns the maximum Z coordinate of a geometry ST_ZMin Returns the minimu...Signatures UTINYINT ST_ZMFlag (geom GEOMETRY) UTINYINT ST_ZMFlag (wkb WKB_BLOB) Description Returns a flag indicating the presence of Z and M values in the input geometry. 0 = No Z or M values 1 = M values only 2 = Z values only 3 = Z and M values Examp... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- FROM and JOIN Clauses 8051
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...csv('test.csv') WITH ORDINALITY; Note that the same result could be achieved using the row_number window function . In the presence of joins , however, WITH ORDINALITY allows enumerating one side of the join instead of the final result set, without havin... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- COPY Statement 7724
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...tbl' (DELIMITER '|'); Copy the contents of lineitem.tbl into the lineitem table, where the delimiter, quote character, and presence of a header are automatically detected: COPY lineitem FROM 'lineitem.tbl' (AUTO_DETECT true); Read the contents of a comma... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work