Results of 1 - 10 of about 19 for starts (0.003 sec.)
- Prepared Statements – DuckDB 13574
- 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
...S ( 'Alice' , 37 ), ( 'Ana' , 35 ), ( 'Bob' , 41 ), ( 'Bea' , 25 ); In our example query, we'll look for people whose name starts with a B and are at least 40 years old. This will return a single row <'Bob', 41> . Auto-Incremented Parameters: ? DuckDB...corresponds to their position in the execution statement. For example: PREPARE query_person AS SELECT * FROM person WHERE starts_with ( name , ? ) AND age >= ? ; Using the CLI client, the statement is executed as follows. EXECUTE query_person ( 'B' ,...where parameters are denoted with an integer ( $1 , $2 ). For example: PREPARE query_person AS SELECT * FROM person WHERE starts_with ( name , $ 2 ) AND age >= $ 1 ; Using the CLI client, the statement is executed as follows. Note that the first param... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/prepared_statements.html
- Date Part Functions – DuckDB 12243
- 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
...7991984 era Gregorian era (CE/AD, BCE/BC) 1 isodow ISO day of the week (Monday = 1, Sunday = 7) 2 isoyear ISO Year number (Starts on Monday of week containing Jan 4th) 2021 timezone_hour Time zone offset hour portion 0 timezone_minute Time zone offset...yofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturday = 6). dayofyear(date) Day of the year (starts from 1, i.e., January 1 = 1). decade(date) Decade (year / 10). epoch(date) Seconds since 1970-01-01. era(date) Calendar er...a. hour(date) Hours. isodow(date) Numeric ISO weekday (Monday = 1, Sunday = 7). isoyear(date) ISO Year number (Starts on Monday of week containing Jan 4th). microsecond(date) Sub-minute microseconds. millennium(date) Millennium. millisecond... - https://man.mtool.work/duckdb/1.3/sql/functions/datepart.html
- CALL Statement – DuckDB 9818
- 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
...nvoke the 'pragma_table_info' table function: CALL pragma_table_info ( 'pg_am' ); Select only the functions where the name starts with ST_ : SELECT function_name , parameters , parameter_types , return_type FROM duckdb_functions () WHERE function_name...ctions duckdb Invoke pragma info Documentation Statements Copy Markdown Statement statement invokes given results Examples starts parameters parameter types return type Syntax 関連するページ Nested Functions Replacement Scans query and query_table Func... - https://man.mtool.work/duckdb/1.3/sql/statements/call.html
- Text Functions – DuckDB 9596
- 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
...arch_string in string , counting from 1. Returns 0 if no match found. prefix(string, search_string) Returns true if string starts with search_string . printf(format, ...) Formats a string using printf syntax . read_text(source) Returns the content from...ndex of the list. If the index is outside the bounds of the list, return an empty string (to match PostgreSQL's behavior). starts_with(string, search_string) Returns true if string begins with search_string . str_split(string, separator) Splits the str...ing ^@ search_string Description Returns true if string begins with search_string . Example 'abc' ^@ 'a' Result true Alias starts_with arg1 || arg2 Description Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Information Schema – DuckDB 9374
- 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
...s' column_name Name of the column. VARCHAR 'price' ordinal_position Ordinal position of the column within the table (count starts at 1). INTEGER 5 column_default Default expression of the column. VARCHAR 1.99 is_nullable YES if the column is possibly n...ted by this constraint. VARCHAR 'exam_id' ordinal_position Ordinal position of the column within the constraint key (count starts at 1). INTEGER 1 position_in_unique_constraint For a foreign-key constraint, ordinal position of the referenced column wit...hin its unique constraint (count starts at 1 ); otherwise NULL . INTEGER 1 referential_constraints : Referential Constraints Column Description Type Example const... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Date Format Functions – DuckDB 8708
- 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
...ber. 0, 1, …, 59 %u ISO 8601 weekday as a decimal number where 1 is Monday. 1, 2, …, 7 %U Week number of the year. Week 01 starts on the first Sunday of the year, so there can be week 00. Note that this is not compliant with the week date standard in I...%Y . Use the ISO year %G instead. 01, …, 53 %w Weekday as a decimal number. 0, 1, …, 6 %W Week number of the year. Week 01 starts on the first Monday of the year, so there can be week 00. Note that this is not compliant with the week date standard in I... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
- JSON Processing Functions – DuckDB 8264
- 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
...2, 3]}' , '/duck/0' ); 1 The JSONPath syntax separates fields with a . , and accesses array elements with [i] , and always starts with $ . Using the same example, we can do the following: SELECT json_extract ( '{"duck": [1, 2, 3]}' , '$.duck[0]' ); 1 N...he element is not an array or object, the element itself is returned. If the optional path argument is supplied, traversal starts from the element at the given path instead of the root element. The resulting table has the following columns: Field Type... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Command Line Arguments – DuckDB 7820
- 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
...MAND and exit -separator SEP Set output column separator to SEP . Default: | -table Set output mode to table -ui Loads and starts the DuckDB UI . If the UI is not yet installed, it installs the ui extension -unsigned Allow loading of unsigned extension... - https://man.mtool.work/duckdb/1.3/clients/cli/arguments.html
- ODBC Configuration – DuckDB 7820
- 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
...t.ini The odbcinst.ini file contains general configurations for the ODBC installed drivers in the system. A driver section starts with the driver name between brackets, and then it follows specific configuration knobs belonging to that driver. Example... - https://man.mtool.work/duckdb/1.3/clients/odbc/configuration.html
- Enum Functions – DuckDB 7820
- 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
...two given enum values as an array. The values must be of the same enum type. When the first parameter is NULL , the result starts with the first value of the enum type. When the second parameter is NULL , the result ends with the last value of the enum... - https://man.mtool.work/duckdb/1.3/sql/functions/enum.html
DuckDB 1.3 Documentation / man.mtool.work