Results of 1 - 10 of about 370 for macro (0.005 sec.)
- CREATE MACRO Statement – DuckDB 16458
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Statements Copy Markdown CREATE MACRO Statement The CREATE MACRO statement can create a scalar or table macro (function) in the catalog. A macro may only be a s... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- Sharing Macros – DuckDB 13541
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...orage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Guides / Snippets Copy Markdown Sharing Macros DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we... - https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
- COMMENT ON Statement – DuckDB 10396
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...'very nice sequence' ; Create a comment on a TYPE : COMMENT ON TYPE test_type IS 'very nice type' ; Create a comment on a MACRO : COMMENT ON MACRO test_macro IS 'very nice macro' ; Create a comment on a MACRO TABLE : COMMENT ON MACRO TABLE test_table... - https://man.mtool.work/duckdb/1.3/sql/statements/comment_on.html
- DROP Statement – DuckDB 7700
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...ON fn ; Drop index idx : DROP INDEX idx ; Drop schema sch : DROP SCHEMA sch ; Drop sequence seq : DROP SEQUENCE seq ; Drop macro mcr : DROP MACRO mcr ; Drop macro table mt : DROP MACRO TABLE mt ; Drop type typ : DROP TYPE typ ; Syntax Dependencies of... - https://man.mtool.work/duckdb/1.3/sql/statements/drop.html
- Spatial Functions – DuckDB 5674
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...MemUnion_Agg Computes the union of a set of input geometries. ST_Union_Agg Computes the union of a set of input geometries Macro Functions Function Summary ST_Rotate Alias of ST_RotateZ ST_RotateX Rotates a geometry around the X axis. This is a shorth... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Importing Duckbox Tables – DuckDB 5224
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...uckbox.csv; ' || 'sed "1,4d;\$d;s/^│ *//;s/ *│$//;s/ *│ */│/g" duckbox.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; '... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- Casting – DuckDB 5224
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...NULL :: INTEGER ) AS result ; ┌───────┐ │ res │ │ int32 │ ├───────┤ │ 42 │ └───────┘ This function is primarily useful in macros , as it allows you to maintain types. This helps with making generic macros that operate on different types. For example,... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- DuckDB_% Metadata Functions – DuckDB 5074
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...core repository. VARCHAR duckdb_functions The duckdb_functions() function provides metadata about the functions (including macros) available in the DuckDB instance. Column Description Type database_name The name of the database that contains this func... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Full-Text Search Extension – DuckDB 5004
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...Usage The extension adds two PRAGMA statements to DuckDB: one to create, and one to drop an index. Additionally, a scalar macro stem is added, which is used internally by the extension. PRAGMA create_fts_index create_fts_index ( input_table , input_i... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- query and query_table Functions – DuckDB 4854
- 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 Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DA...xt Search query and query_table Functions Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Troubleshooting Crashes Out o...CUTE select_from_table ( 'my_table' ); i 42 When combined with the COLUMNS expression , we can write very generic SQL-only macros. For example, below is a custom version of SUMMARIZE that computes the min and max of every column in a table: CREATE OR... - https://man.mtool.work/duckdb/1.3/guides/sql_features/query_and_query_table_func...
DuckDB 1.3 Documentation / man.mtool.work