Results of 1 - 10 of about 23 for respectively (0.003 sec.)
- CREATE SEQUENCE Statement – DuckDB 15433
- 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 allows the sequence to wrap around when the maxvalue or minvalue has been reached by an ascending or descending sequence respectively. If the limit is reached, the next number generated will be the minvalue or maxvalue , respectively. If NO CYCLE is specif...E is specified, then default values will be used. The defaults are 2^63 - 1 and -1 for ascending and descending sequences, respectively. minvalue The optional clause MINVALUE minvalue determines the minimum value a sequence can generate. If this clause is no...VALUE is specified, then defaults will be used. The defaults are 1 and -(2^63 - 1) for ascending and descending sequences, respectively. name The name (optionally schema-qualified) of the sequence to be created. start The optional clause START WITH start all... - https://man.mtool.work/duckdb/1.3/sql/statements/create_sequence.html
- query and query_table Functions – DuckDB 10590
- 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
...ns The query and query_table functions take a string literal, and convert it into a SELECT subquery and a table reference, respectively. Note that these functions only accept literal strings. As such, they are not as powerful (or dangerous) as a generic eval...y powerful generic example summarize Documentation Guides Features Copy Markdown Functions take convert subquery reference respectively Note these 関連するページ Summarize DESCRIBE Statement CALL Statement SELECT Clause SUMMARIZE Statement Import from Pandas... - https://man.mtool.work/duckdb/1.3/guides/sql_features/query_and_query_table_func...
- Conversion between DuckDB and Python – DuckDB 9199
- 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
...urn NULL if it returns true . We check against datetime.datetime.min 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 tzin....date date converts to the DATE type. We check against datetime.date.min and datetime.date.max to convert to -inf and +inf respectively. bytes bytes converts to BLOB by default, when it's used to construct a Value object of type BITSTRING , it maps to BITSTR... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Numeric Types – DuckDB 9199
- 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
...types are usually implementations of IEEE Standard 754 for Binary Floating-Point Arithmetic (single and double precision, respectively), to the extent that the underlying processor, operating system, and compiler support it. Name Aliases Description FLOAT F...numbers ourside the mirrored ranges) may cause errors on some platforms but will usually be converted to zero or infinity, respectively. In addition to ordinary numeric values, the floating-point types have several special values representing IEEE 754 specia... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- List Tables – DuckDB 8512
- 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
...eover, DuckDB defines sqlite_master and many PostgreSQL system catalog tables for compatibility with SQLite and PostgreSQL respectively. 関連キーワード schema tables command used obtain list within table column memory PostgreSQL Documentation Guides Meta Que... - https://man.mtool.work/duckdb/1.3/guides/meta/list_tables.html
- ODBC Configuration – DuckDB 8160
- 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
...ion, 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 details, see the pages for Linux , macOS , and Windows . odbc.ini and .od... - https://man.mtool.work/duckdb/1.3/clients/odbc/configuration.html
- Parquet Encryption – DuckDB 8160
- 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
...the lineitem table from TPC-H at SF1, which is 6M rows and 15 columns, from/to a Parquet file takes 0.26 and 0.99 seconds, respectively. With encryption, this takes 0.64 and 2.21 seconds, both approximately 2.5× slower than the unencrypted version. 関連キーワ... - https://man.mtool.work/duckdb/1.3/data/parquet/encryption.html
- Excel Export – DuckDB 8160
- 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" so that they appear as dates or times when opened in Excel. TIMESTAMP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make the... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_export.html
- Directly Reading Files – DuckDB 8160
- 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
...tions accept a filename, a list of filenames or a glob pattern, and output the content of each file as a VARCHAR or BLOB , respectively, as well as additional metadata such as the file size and last modified time. read_text The read_text table function reads... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Node.js API – DuckDB 7808
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...ntext. Connection objects also contain shorthands to directly call run() , all() and each() with parameters and callbacks, respectively, for example: con . all ( ' SELECT 42 AS fortytwo ' , function ( err , res ) { if ( err ) { console . warn ( err ); return... - https://man.mtool.work/duckdb/1.3/clients/nodejs/overview.html
DuckDB 1.3 Documentation / man.mtool.work