Results of 1 - 8 of about 8 for direction (0.005 sec.)
- ORDER BY Clause 13013
- ORDER BY is an output modifier. Logically it is applied near the very end of the query (just prior to LIMIT or OFFSET , if present). The ORDER BY clause sorts the rows on the sorting criteria in either ascending or descending order. In addi
.... ORDER BY ALL The ALL keyword indicates that the output should be sorted by every column in order from left to right. The direction of this sort may be modified using either ORDER BY ALL ASC or ORDER BY ALL DESC and/or NULLS FIRST or NULLS LAST . Note th...s ASC and NULLS LAST , i.e., the values are sorted in ascending order and NULL values are placed last. For the default ASC direction this matches PostgreSQL. Note, however, that DuckDB keeps NULLS LAST even for DESC ordering, whereas PostgreSQL places NUL...L s first on DESC (it treats NULL as the largest value). To match PostgreSQL in both directions, set default_null_order = 'NULLS_LAST_ON_ASC_FIRST_ON_DESC' . The default sort order can be changed with the following co... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/orderby.html
- Spatial Functions 10917
- 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
...a point as a fraction of the total 2D length of the line. ST_LineMerge "Merges" the input line geometry, optionally taking direction into account. ST_LineString2DFromWKB Deserialize a LINESTRING_2D from a WKB encoded blob ST_LineSubstring Returns a substr.... This is a shorthand macro for calling ST_Affine. ST_Scale ST_TransScale Translates and then scales a geometry in X and Y direction. This is a shorthand macro for calling ST_Affine. ST_Translate Table Functions Function Summary ST_Drivers Returns the lis...of the line. ST_LineMerge Signatures GEOMETRY ST_LineMerge (geom GEOMETRY) GEOMETRY ST_LineMerge (geom GEOMETRY, preserve_direction BOOLEAN) Description "Merges" the input line geometry, optionally taking direction into account. ST_LineString2DFromWKB Si... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Numeric Functions 8838
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...the base-2 log of x . multiply(x, y) Alias for x * y . nextafter(x, y) Return the next floating point value after x in the direction of y . pi() Returns the value of pi. pow(x, y) Computes x to the power of y . power(x, y) Alias of pow . Computes x to the...mple | multiply(2, 3) | | Result | 6 | nextafter(x, y) | Description | Return the next floating point value after x in the direction of y . | | Example | nextafter(1::float, 2::float) | | Result | 1.0000001 | pi() | Description | Returns the value of pi.... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Migrating to DuckDB 2.0 8043
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...0 storage format. By default, every new database file created by v2.0.0 uses this format ( storage version 69 ). The other direction keeps working: DuckDB 2.0.0 can read and write existing database files created by earlier versions. These files keep their... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- UNPIVOT Statement 8043
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...UNPIVOT ⟨dataset⟩ ON ⟨column(s)⟩ INTO NAME ⟨name_column_name⟩ VALUE ⟨value_column_name(s)⟩ ORDER BY ⟨column(s)_with_order_direction(s)⟩ LIMIT ⟨number_of_rows⟩; Example Data All examples use the dataset produced by the queries below: CREATE OR REPLACE TAB... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Conversion between DuckDB and Python 7790
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...to import . datetime.datetime.max and datetime.datetime.min convert to ordinary timestamps, not to infinity. In the other direction, the timestamp infinity is returned as datetime.datetime.max and -infinity as datetime.datetime.min . datetime.time If the... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Python Client API 7790
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...Expression The values gathered into a list. SQL: array_agg . as_order ( ) → str The SQL for an ORDER BY item, carrying the direction and the null order where they were asked for. as_select ( ) → str The SQL for a select list, carrying the alias if there i...→ Expression How many distinct values there are, ignoring NULL. nulls_first ( ) → Expression Where NULLs sort. Leaves the direction as it was, so the connection's default holds until one is given. nulls_last ( ) → Expression Where NULLs sort. Leaves the... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Pragmas 7790
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...ull_order = 'NULLS_FIRST'; SET default_null_order = 'NULLS_LAST_ON_ASC_FIRST_ON_DESC'; Set the default result set ordering direction to ASCENDING or DESCENDING : SET default_order = 'ASCENDING'; SET default_order = 'DESCENDING'; Ordering by Non-Integer Li... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work