Results of 1 - 10 of about 44 for otherwise (0.006 sec.)
- Regular Expressions – DuckDB 12970
- 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
...0][, options]) If string contains the regexp pattern , returns the capturing group specified by optional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional o...If string contains the regexp pattern , returns the capturing groups as a struct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]...matches the regex . regexp_matches(string, pattern[, options]) Returns true if string contains the regexp pattern , false otherwise. regexp_replace(string, pattern, replacement[, options]) If string contains the regexp pattern , replaces the matching par... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Numeric Functions – DuckDB 12740
- 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
...y . greatest(x1, x2, ...) Selects the largest value. isfinite(x) Returns true if the floating point value is finite, false otherwise. isinf(x) Returns true if the floating point value is infinite, false otherwise. isnan(x) Returns true if the floating poi...nt value is not a number, false otherwise. lcm(x, y) Computes the least common multiple of x and y . least_common_multiple(x, y) Computes the least common multiple...e. Example greatest(3, 2, 4, 4) Result 4 isfinite(x) Description Returns true if the floating point value is finite, false otherwise. Example isfinite(5.5) Result true isinf(x) Description Returns true if the floating point value is infinite, false otherw... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Comparisons – DuckDB 10112
- 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
...x <= a AND a <= y a NOT BETWEEN x AND y equivalent to x > a OR a > y expression IS NULL true if expression is NULL , false otherwise expression ISNULL alias for IS NULL (non-standard) expression IS NOT NULL false if expression is NULL , true otherwise exp...ese DuckDB equivalent shows Operator Example less greater including Combination Casting casts PostgreSQL stricter checking otherwise 関連するページ Caveats TRY expression Expressions Logical Operators Relational API on Pandas List Type See this page as Ma... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Date Functions – DuckDB 9866
- 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
...ubfield from a date. greatest(date, date) The later of two dates. isfinite(date) Returns true if the date is finite, false otherwise. isinf(date) Returns true if the date is infinite, false otherwise. julian(date) Extract the Julian Day number from a date...TE '1992-09-20', DATE '1992-03-07') Result 1992-09-20 isfinite(date) Description Returns true if the date is finite, false otherwise. Example isfinite(DATE '1992-03-07') Result true isinf(date) Description Returns true if the date is infinite, false other... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Installing and Loading the JSON extension – DuckDB 9144
- 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
...N Files Copy Markdown Installing and Loading the JSON extension The json extension is shipped by default in DuckDB builds, otherwise, it will be transparently autoloaded on first use. If you would like to install and load it manually, run: INSTALL json ;...; 関連キーワード json extension Documentation Import Files Copy Markdown Installing Loading shipped default DuckDB builds otherwise transparently autoloaded first like install load manually 関連するページ ICU Extension JSON Import Creating JSON Building... - https://man.mtool.work/duckdb/1.3/data/json/installing_and_loading.html
- Timestamp Functions – DuckDB 9144
- 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
...test(timestamp, timestamp) The later of two timestamps. isfinite(timestamp) Returns true if the timestamp is finite, false otherwise. isinf(timestamp) Returns true if the timestamp is infinite, false otherwise. julian(timestamp) Extract the Julian Day num...01:02:03.1234') Result 1992-09-20 20:38:48 isfinite(timestamp) Description Returns true if the timestamp is finite, false otherwise. Example isfinite(TIMESTAMP '1992-03-07') Result true isinf(timestamp) Description Returns true if the timestamp is infini...te, false otherwise. Example isinf(TIMESTAMP '-infinity') Result true julian(timestamp) Description Extract the Julian Day number from a times... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Conversion between DuckDB and Python – DuckDB 8913
- 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
...and datetime.datetime.max to convert to -inf and +inf respectively. If the datetime has tzinfo, we will use TIMESTAMPTZ , otherwise it becomes TIMESTAMP . datetime.time If the time has tzinfo, we will use TIMETZ , otherwise it becomes TIME . datetime.dat...f the union member types: VARCHAR[], BIGINT[] The names of the fields matter and the two lists need to have the same size. Otherwise we'll try to convert it to a STRUCT . import duckdb my_struct_dict = { 1 : "one" , "2" : 2 , "three" : [ 1 , 2 , 3 ], Fals... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Python Client API – DuckDB 8913
- 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
...duckdb.DuckDBPyRelation ¶ Run a SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. get_table_names ( self : duckdb.duckdb.DuckDBPyConnection , query : str ) → set [ str ] ¶ Extract the...duckdb.DuckDBPyRelation ¶ Run a SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. read_csv ( self : duckdb.duckdb.DuckDBPyConnection , path_or_buffer : object , ** kwargs ) → duckdb.d...duckdb.DuckDBPyRelation ¶ Run a SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. sqltype ( self : duckdb.duckdb.DuckDBPyConnection , type_str : str ) → duckdb.duckdb.typing.DuckDBPyT... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Spatial Functions – DuckDB 8913
- 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
...geometries are LINESTRING 's, a MULTILINESTRING is returned. If all geometries are POLYGON 's, a MULTIPOLYGON is returned. Otherwise if the input collection contains a mix of geometry types, a GEOMETRYCOLLECTION is returned. Empty and NULL geometries are...t will be returned as is. If the input geometry has both a Z component and a M component, the Z component will be removed. Otherwise, if the input geometry has neither a Z or M component, the new M value will be added to the vertices of the input geometry...t will be returned as is. If the input geometry has both a Z component and a M component, the M component will be removed. Otherwise, if the input geometry has neither a Z or M component, the new Z value will be added to the vertices of the input geometry... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Text Functions – DuckDB 8913
- 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
...oup][, options]) If string contains the regex pattern, returns the capturing group specified by optional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional r...) If string contains the regex pattern, returns the capturing groups as a struct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. A set of optional regex options can be set. regexp_extra...ional regex options can be set. regexp_matches(string, regex[, options]) Returns true if string contains the regex , false otherwise. A set of optional regex options can be set. regexp_replace(string, regex, replacement[, options]) If string contains the... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
DuckDB 1.3 Documentation / man.mtool.work