Results of 1 - 9 of about 9 for brackets (0.001 sec.)
- Pattern Matching 12546
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...ldcard to match any single character and the asterisk ( * ) to match zero or more characters. In addition, you can use the bracket syntax ( [...] ) to match any single character contained within the brackets, or within the character range specified by th...e brackets. An exclamation mark ( ! ) may be used inside the first bracket to search for a character that is not contained within the...brackets. To learn more, visit the “glob (programming)” Wikipedia page . GLOB The GLOB operator returns true or false if the string... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- ODBC Configuration 11827
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
.../path/to/database.duckdb access_mode = read_only The lines correspond to the following parameters: [DuckDB] : between the brackets is a DSN for the DuckDB. Driver : Describes the driver's name, as well as where to find the configurations in the odbcinst...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 of odbcinst.ini with the DuckDB: [ODBC... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- Syntax Highlighting 8987
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
...n start-up of the CLI. Error Highlighting The shell has support for highlighting certain errors. In particular, mismatched brackets and unclosed quotes are highlighted in red (or another color if specified). This highlighting is automatically disabled fo... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- Debugging 8502
- The purpose of the tests is to figure out when things break. Inevitably changes made to the system will cause one of the tests to fail, and when that happens the test needs to be debugged. First, it is always recommended to run in debug mod
...imple_projection.test All tests in a given directory can be executed by providing the directory as a parameter with square brackets. To run all tests in the “projection” directory: build/debug/test/unittest "[projection]" All tests, including the slow te... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/debugging.html
- Array Type 8268
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...3]), (20, [4, 5, 6]); Retrieving Values from Arrays Retrieving one or more values from an array can be accomplished using brackets and slicing notation, or through list functions like list_extract and array_extract . Using the example in Defining an Arr... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- List Type 8268
- A LIST column encodes lists of values. Fields in the column can have values with different lengths, but they must all have the same underlying type. LIST s are typically used to store arrays of numbers, but can contain any uniform data type
...EGER[], varchar_list VARCHAR[]); Retrieving from Lists Retrieving one or more values from a list can be accomplished using brackets and slicing notation, or through list functions like list_extract . Multiple equivalent functions are provided as aliases... - https://man.mtool.work/duckdb/2.0/sql/data_types/list.html
- Friendly SQL 7783
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...omprehensions List slicing and indexing from the back ( [-1] ) String slicing STRUCT.* notation Creating LIST using square brackets Simple LIST and STRUCT creation Updating the schema of STRUCT s Join Types ASOF joins LATERAL joins POSITIONAL joins NEARE... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Dot Commands 7315
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...playing of completion prompts in the shell on / off .render_errors ⟨on/off⟩ Toggle rendering of errors (such as mismatched brackets and unclosed quotes) in the shell on / off . See the Syntax Highlighting page .rows Row-wise rendering of query results (d... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Struct Data Type 7315
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...single quotes ( ' ) since the goal is to specify a certain string key and only constant expressions may be used inside the brackets (no expressions): SELECT a['x space'] FROM (SELECT {'x space': 1, 'y': 2, 'z': 3} AS a); The struct_extract function is al... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work