Results of 1 - 8 of about 8 for printf (0.008 sec.)
- Text Functions – DuckDB 11766
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...ting 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 source (a filename, a list...ing, search_string) Description Returns true if string starts with search_string . Example prefix('abc', 'ab') Result true printf(format, ...) Description Formats a string using printf syntax . Example printf('Benchmark "%s" took %d seconds', 'CSV', 42... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Vectors – DuckDB 11151
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...the rows for ( idx_t row = 0 ; row < row_count ; row ++ ) { if ( duckdb_validity_row_is_valid ( vector_validity , row )) { printf ( "%lld \n " , vector_data [ row ]); } else { printf ( "NULL \n " ); } } duckdb_destroy_data_chunk ( & result ); } // clea...idity , row )) { duckdb_string_t str = vector_data [ row ]; if ( duckdb_string_is_inlined ( str )) { // use inlined string printf ( "%.*s \n " , str . value . inlined . length , str . value . inlined . inlined ); } else { // follow string pointer print... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Query – DuckDB 10736
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...r the rows for ( idx_t row = 0 ; row < row_count ; row ++ ) { if ( duckdb_validity_row_is_valid ( col1_validity , row )) { printf ( "%d" , col1_data [ row ]); } else { printf ( "NULL" ); } printf ( "," ); if ( duckdb_validity_row_is_valid ( col2_validi...ty , row )) { printf ( "%d" , col2_data [ row ]); } else { printf ( "NULL" ); } printf ( " \n " ); } duckdb_destroy_data_chunk ( & result ); }... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Sharing Macros – DuckDB 9145
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...ows: duckdb pretty_print_integer_macro.duckdb CREATE MACRO pretty_print_integer ( n ) AS CASE WHEN n >= 1_000_000_000 THEN printf ( '%dB' , n // 1_000_000_000 ) WHEN n >= 1_000_000 THEN printf ( '%dM' , n // 1_000_000 ) WHEN n >= 1_000 THEN printf ( '%...dk' , n // 1_000 ) ELSE printf ( '%d' , n ) END ; SELECT pretty_print_integer ( 25_500_000 ) AS x ; ┌─────────┐ │ x │ │ varchar │ ├─────────┤ │ 25M │ └──... - https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
- Go Client – DuckDB 7410
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...if errors . Is ( err , sql . ErrNoRows ) { log . Println ( "no rows" ) } else if err != nil { log . Fatal ( err ) } fmt . Printf ( "id: %d, name: %s \n " , id , name ) } More Examples For more examples, see the examples in the duckdb-go repository . 関... - https://man.mtool.work/duckdb/1.3/clients/go.html
- Importing Duckbox Tables – DuckDB 7410
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...ox.csv) |' , delim = '│' ); We can also create a table macro : CREATE MACRO read_duckbox ( path ) AS TABLE FROM read_csv ( printf ( '(sed -n "2s/^│ *//;s/ *│$//;s/ *│ */│/p;2q" %s; ' || 'sed "1,4d;\$d;s/^│ *//;s/ *│$//;s/ *│ */│/g" %s) |' , path , path... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- Friendly SQL – DuckDB 7338
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...ator for function chaining : SELECT ('hello').upper() String formatters: the format() function with the fmt syntax and the printf() function List comprehensions List slicing and indexing from the back ( [-1] ) String slicing STRUCT.* notation Creating... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- Complete API – DuckDB 7265
- 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
...le Troubleshooting Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Logging Overview Securing DuckDB Overview Embedding DuckDB Se...NTEGER , rows can be accessed in the following manner: int32_t * data = ( int32_t * ) duckdb_column_data ( & result , 0 ); printf ( "Data for row %d: %d \n " , row , data [ row ]); Syntax void * duckdb_column_data ( duckdb_result * result , idx_t col )...* ) duckdb_column_data ( & result , 0 ); bool * nullmask = duckdb_nullmask_data ( & result , 0 ); if ( nullmask [ row ]) { printf ( "Data for row %d: NULL \n " , row ); } else { printf ( "Data for row %d: %d \n " , row , data [ row ]); } Syntax bool *... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work