Results of 1 - 10 of about 64 for alias (0.006 sec.)
- List Functions 14071
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...list2 Alias for list_distance . list1 <=> list2 Alias for list_cosine_distance . list1 <@ list2 Alias for list_has_all . list1 @> list...2 Alias for list_has_all . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also conca...t(arg1, arg2, ...) and list_concat(list1, list2, ...) . aggregate(list, function_name, ...) Alias for list_aggregate . apply(list, lambda(x)) Alias for list_transform . array_aggr(list, function_name, ...) Alias for list... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Text Functions 11817
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...g ). string SIMILAR TO regex Returns true if the string matches the regex (see Pattern Matching ). string ^@ search_string Alias for starts_with . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat...whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Alias for to_base64 . bin(string) Converts the string to binary representation. bit_length(string) Number of bits in a string ....char_length(string) Alias for length . character_length(string) Alias for length . chr(code_point) Returns a character which is corresponding the AS... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Numeric Functions 10797
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...// 2 2 % Modulo (remainder) 5 % 4 1 ** Exponent 3 ** 4 81 ^ Exponent (alias for ** ) 3 ^ 4 81 & Bitwise AND 91 & 15 11 | Bitwise OR 32 | 3 35 << Bitwise shift left 1 << 4 16 >> Bitwise shift right 8...bsolute value. acos(x) Computes the inverse cosine of x . acosh(x) Computes the inverse hyperbolic cosine of x . add(x, y) Alias for x + y . asin(x) Computes the inverse sine of x . asinh(x) Computes the inverse hyperbolic sine of x . atan(x) Computes...that are set. cbrt(x) Returns the cube root of the number. ceil(x) Rounds the number up. ceiling(x) Rounds the number up. Alias of ceil . cos(x) Computes the cosine of x . cosh(x) Computes the hyperbolic cosine of x . cot(x) Computes the cotangent of... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Relational API 9548
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...ry that reads is lazy evaluated . Name Description from_arrow Create a relation object from an Arrow object. from_csv_auto Alias of read_csv() . from_df Create a relation object from the DataFrame in df. from_parquet Alias of read_parquet() . from_que...ry Alias of sql() . query Alias of sql() . read_csv Create a relation object from the CSV file in 'name'. read_json Create a relati...──────┘ from_csv_auto from_csv_auto(self: _duckdb.DuckDBPyConnection, *args: object, **kwargs: object) -> DuckDBPyRelation Alias of read_csv() . from_df from_df(self: _duckdb.DuckDBPyConnection, df: object) -> DuckDBPyRelation Create a relation object... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Aggregate Functions 9491
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...of the arg or val expression is NULL are ignored. This function is affected by ordering . | | Example | arg_max(A, B) | | Alias(es) | argmax(arg, val) , max_by(arg, val) | arg_max(arg, val, n) | Description | The generalized case of arg_max for n val...s for the top n rows ordered by val descending. This function is affected by ordering . | | Example | arg_max(A, B, 2) | | Alias(es) | argmax(arg, val, n) , max_by(arg, val, n) | arg_max_null(arg, val) | Description | Finds the row with the maximum va...of the arg or val expression is NULL are ignored. This function is affected by ordering . | | Example | arg_min(A, B) | | Alias(es) | argmin(arg, val) , min_by(arg, val) | arg_min(arg, val, n) | Description | The generalized case of arg_min for n val... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Blob Functions 9045
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...ist_concat(list1, list2, ...) . base64(blob) Alias for to_base64 . decode(blob[, on_error]) Converts blob to VARCHAR . The optional on_error parameter controls handling of i...literal encoding. from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . hex(blob) Converts blob to VARCHAR using hexadecimal encoding. md5(blob) Ret...rns a VARCHAR with the SHA-256 hash of the blob . to_base64(blob) Converts a blob to a base64 encoded string. to_hex(blob) Alias for hex . unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecim... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Struct Functions 8600
- 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
...ct_keys , struct_update and remap_struct , require a STRUCT . Name Description struct.entry Dot notation that serves as an alias for struct_extract from named STRUCT s. struct[entry] Bracket notation that serves as an alias for struct_extract from nam...ed STRUCT s. struct[idx] Bracket notation that serves as an alias for struct_extract from TUPLE s, using an index (1-based). remap_struct(input, target_type, mapping, defaults) Remap a STR...ruct_values(struct) Return the values of a STRUCT as a TUPLE . struct.entry | Description | Dot notation that serves as an alias for struct_extract from named STRUCT s. | | Example | ({'i': 3, 's': 'string'}).i | | Result | 3 | struct[entry] | Descrip... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Types 8428
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...Logical Type Interface duckdb_logical_type duckdb_create_logical_type ( duckdb_type type ); char * duckdb_logical_type_get_alias ( duckdb_logical_type type ); void duckdb_logical_type_set_alias ( duckdb_logical_type type , const char * alias ); duckdb...duckdb_type type ); Parameters type : The primitive type to create. Return Value The logical type. duckdb_logical_type_get_alias Returns the alias of a duckdb_logical_type, if set, else nullptr . The result must be destroyed with duckdb_free . Syntax...char * duckdb_logical_type_get_alias ( duckdb_logical_type type ); Parameters type : The logical type Return Value The alias or nullptr duckdb_logical_type_set... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Time Functions 8371
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...the local time zone, as a TIME value without a time zone. | | Example | current_localtime() | | Result | 06:09:59.988 | | Alias | localtime (no parentheses necessary) | date_diff(part, starttime, endtime) | Description | The number of part boundaries...me and exclusive of the smaller time. | | Example | date_diff('hour', TIME '01:02:03', TIME '06:01:03') | | Result | 5 | | Alias | datediff | date_part(part, time) | Description | Get subfield (equivalent to extract ). | | Example | date_part('minute'..., TIME '14:21:13') | | Result | 21 | | Alias | datepart | date_sub(part, starttime, endtime) | Description | The signed length of the interval between starttime and en... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Lambda Functions 8198
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...flexible expressions in queries. Scalar Functions That Accept Lambda Functions Function Description apply(list, lambda(x)) Alias for list_transform . array_apply(list, lambda(x)) Alias for list_transform . array_filter(list, lambda(x)) Alias for list_...filter . array_reduce(list, lambda(x,y)[, initial_value]) Alias for list_reduce . array_transform(list, lambda(x)) Alias for list_transform . filter(list, lambda(x)) Alias for list_filte...r . list_apply(list, lambda(x)) Alias for list_transform . list_filter(list, lambda(x)) Constructs a list from those elements of the input list for which the la... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
DuckDB 2.0 Documentation / man.mtool.work