⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 4 of about 4 for vertices (0.002 sec.)
Spatial Functions 12408
Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR ... Returns a new geometry with the coordinates of the input geometry "flipped" so that x = y and y = x ST_Force2D Forces the vertices of a geometry to have X and Y components ST_Force3DM Forces the vertices of a geometry to have X, Y and M components ST_Fo ... rce3DZ Forces the vertices of a geometry to have X, Y and Z components ST_Force4D Forces the vertices of a geometry to have X, Y, Z and M components ... y with the given measure ST_LocateBetween Returns a geometry or geometry collection created by filtering and interpolating vertices within a range of "M" values ST_M Returns the M coordinate of a point geometry ST_MMax Returns the maximum M coordinate of ...
https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
Geometry Data Type 8543
Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i ... ch as Z for elevation or M for "measure", or both. The vertex dimensions of a GEOMETRY value must be consistent across all vertices. For example, if one vertex has X , Y , and Z coordinates, then all other vertices in that geometry must also have X , Y , ... and Z coordinates. This means that you cannot have a mix of 2D and 3D vertices within the same geometry. This also applies for collections of geometries, such as MULTIPOINT or GEOMETRYCOLLECTION , wher ... can also be "empty" (e.g., POINT EMPTY , LINESTRING EMPTY , MULTIPOLYGON EMPTY , etc.) which means they don't contain any vertices. Empty geometries are still valid geometries and can be used in spatial operations, but they are mostly useful for represe ...
https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
Vector Similarity Search Extension 8025
The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S ... eters of the index construction and search process: Option Default Description ef_construction 128 The number of candidate vertices to consider during the construction of the index. A higher value will result in a more accurate index, but will also incre ... ase the time it takes to build the index. ef_search 64 The number of candidate vertices to consider during the search phase of the index. A higher value will result in a more accurate index, but will also incre ...
https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
Graph Queries 7951
DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for ... nd GRAPH_TABLE ), run: SET active_grammar_extensions = ['duckpgq']; Creating a Property Graph A property graph consists of vertices (nodes) and edges (relationships). You create one as a layer on top of existing tables: CREATE TABLE Person (id BIGINT, na ...
https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work