Results of 1 - 10 of about 42 for point (0.009 sec.)
- Spatial Functions – DuckDB 15808
- 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
...Ingestion Query Extensions SQL Introduction 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...e geometry as a WKB (Well-Known-Binary) blob ST_Azimuth Returns the azimuth (a clockwise angle measured from north) of two points in radian. ST_Boundary Returns the "boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the t...yped multi geometry. ST_ConcaveHull Returns the 'concave' hull of the input geometry, containing all of the source input's points, and which can be used to create polygons from points. The ratio parameter dictates the level of concavity; 1.0 returns t... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Numeric Types – DuckDB 12898
- 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
...Ingestion Query Extensions SQL Introduction 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...its, rounded up to 16, becomes two extra bytes). Both negative and positive values are supported by the VARINT type. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact f...ixed-point decimal value. When creating a value of type DECIMAL , the WIDTH and SCALE can be specified to define which size of decima... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Numeric Functions – DuckDB 8701
- 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
...Ingestion Query Extensions SQL Introduction 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...equivalent when at least one of the operands is a FLOAT or a DOUBLE . When both operands are integers, / performs floating points division ( 5 / 2 = 2.5 ) while // performs integer division ( 5 // 2 = 2 ). Supported Types The modulo, bitwise, and nega...test common divisor of x and y . greatest(x1, x2, ...) Selects the largest value. isfinite(x) Returns true if the floating point value is finite, false otherwise. isinf(x) Returns true if the floating point value is infinite, false otherwise. isnan(x)... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Non-Deterministic Behavior – DuckDB 8113
- 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
...Ingestion Query Extensions SQL Introduction 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...y_distinct ([ 'A' , 'A' , 'B' , NULL , NULL ]) AS arr ; For this query, both [A, B] and [B, A] are valid results. Floating-Point Aggregate Operations with Multi-Threading Floating-point inaccuracies may produce different results when run in a multi-th...of s . However, when executed on multiple threads, the query may return small numbers ( 0 <= z < 10e-16 ) due to floating-point inaccuracies. Working Around Non-Determinism For the majority of use cases, non-determinism is not causing any issues. How... - https://man.mtool.work/duckdb/1.3/operations_manual/non-deterministic_behavior.h...
- Timestamp Types – DuckDB 8020
- 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
...Ingestion Query Extensions SQL Introduction 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...ecution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Timestamp Types Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string fo...he INT64 number of non-leap microseconds since the Unix epoch 1970-01-01 00:00:00+00 , and thus unambiguously identifies a point in absolute time, or instant . The reason for the labels time zone aware and WITH TIME ZONE is that timestamp arithmetic,... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- PostgreSQL Compatibility – DuckDB 7881
- 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
...Ingestion Query Extensions SQL Introduction 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...ct closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by zero. DuckDB conforms to the...IEEE Standard for Floating-Point Arithmetic (IEEE 754) for both division by zero and operations involving infinity values. PostgreSQL returns an error for... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Pragmas – DuckDB 7834
- 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
...Ingestion Query Extensions SQL Introduction 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...ts for e.g., Parquet metadata: PRAGMA enable_object_cache ; Disable caching of objects: PRAGMA disable_object_cache ; Checkpointing Compression During checkpointing, the existing column data + any new changes get compressed. There exist a couple pragm...he listed compression methods from the comma separated list: PRAGMA disabled_compression_methods = 'fsst,rle' ; Force Checkpoint When CHECKPOINT is called when no changes are made, force a checkpoint regardless: PRAGMA force_checkpoint ; Checkpoint on... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- R-Tree Indexes – DuckDB 7741
- 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
...Ingestion Query Extensions SQL Introduction 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...are axis-aligned, i.e., the rectangle is not rotated – the sides are always parallel to the coordinate axes. The MBR of a point is the point itself. By traversing the R-tree from top to bottom, it is possible to very quickly search a R-tree-indexed t...the table is filtered with a spatial predicate: INSTALL spatial ; LOAD spatial ; -- Create a table with 10_000_000 random points CREATE TABLE t1 AS SELECT point :: GEOMETRY AS geom FROM st_generatepoints ({ min_x : 0 , min_y : 0 , max_x : 100 , max_y... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- Aggregate Functions – DuckDB 7741
- 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
...Ingestion Query Extensions SQL Introduction 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...Returns the number of rows in a group where arg is true . favg(arg) Calculates the average using a more accurate floating point summation (Kahan Sum). first(arg) Returns the first value (null or non-null) from arg . This function is affected by order...ing . fsum(arg) Calculates the sum using a more accurate floating point summation (Kahan Sum). geomean(arg) Calculates the geometric mean of all non-null values in arg . histogram(arg) Returns a... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Text Functions – DuckDB 7618
- 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
...Ingestion Query Extensions SQL Introduction 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...using slice conventions . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) a.... char_length(string) Number of characters in string . character_length(string) Number of characters in string . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates mu... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
DuckDB 1.3 Documentation / man.mtool.work