Results of 1 - 10 of about 14 for whereas (0.002 sec.)
- PEG Parser 13916
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...a best-effort legacy experience and preserves several DuckDB 1.5 quirks: ~ and !~ perform full regular expression matches, whereas DuckDB 2.0 defaults to partial matches. The ! operator binds less tightly: 2 * 3! returns 720 ( (2 * 3)! ), whereas DuckDB...red SQL qualifies built-in functions, for example main.struct_pack(x := 1) in view definitions. ORDER BY true is accepted, whereas DuckDB 2.0 rejects a non-integer literal. Column constraints on ALTER TABLE ... ADD COLUMN , such as UNIQUE , are rejected... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Numeric Types 10958
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...T4 and INT8 for signed integers were inherited from PostgreSQL, where digits in these names indicate their size in bytes , whereas the type aliases for their unsigned equivalents, UINT8 , UINT16 , UINT32 and UINT64 , indicate their size in bits followin...7::DECIMAL(1, 0) != 0.6::DECIMAL(1, 0) but it may be surprising that 1.3::FLOAT - 0.7::FLOAT != 0.6::FLOAT . Additionally, whereas multiplication, addition and subtraction of fixed-point decimal data types is exact, these operations are only approximate...not cast to fixed point formats of the same width as in- and outputs. For example, (10::FLOAT / 3::FLOAT)::FLOAT * 3 = 10 whereas (10::DECIMAL(18, 3) / 3::DECIMAL(18, 3))::DECIMAL(18, 3) * 3 = 9.999 . In general: If you require exact storage of numbers... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- PostgreSQL Compatibility 9977
- DuckDB's SQL dialect 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
...SQL is case-insensitive. The way PostgreSQL achieves case insensitivity is by lowercasing unquoted identifiers within SQL, whereas quoting preserves case, e.g., the following command creates a table named mytable but tries to query for MyTaBLe because q...DuckDB's pg_size_pretty function (an alias of format_bytes ) formats sizes using binary (IEC) units such as KiB and MiB , whereas PostgreSQL uses kB and MB . For example, pg_size_pretty(1024) returns 1.0 KiB in DuckDB and 1024 bytes in PostgreSQL, and... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- SQL Introduction 8664
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...join because the table mentioned on the left of the join operator will have each of its rows in the output at least once, whereas the table on the right will only have those rows output that match some row of the left table. When outputting a left-tabl...cts input rows before groups and aggregates are computed (thus, it controls which rows go into the aggregate computation), whereas HAVING selects group rows after groups and aggregates are computed. Thus, the WHERE clause must not contain aggregate func... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- ORDER BY Clause 8664
- 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
...For the default ASC direction this matches PostgreSQL. Note, however, that DuckDB keeps NULLS LAST even for DESC ordering, whereas PostgreSQL places NULL s first on DESC (it treats NULL as the largest value). To match PostgreSQL in both directions, set... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/orderby.html
- Set Operations 8664
- Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,
...NULL NULL Amsterdam NULL 10 2022-10-14 UNION BY NAME follows set semantics (therefore it performs duplicate elimination), whereas UNION ALL BY NAME follows bag semantics. INTERSECT The INTERSECT clause can be used to select all rows that occur in the r... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html
- Secrets Manager 8349
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...nd credential_chain . The CONFIG provider requires the user to pass all configuration information into the CREATE SECRET , whereas the credential_chain provider will automatically try to fetch credentials. When no Secret Provider is specified, the CONFI... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- FILTER Clause 8017
- The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific
...into columns rather than re-aggregate it. For list and array_agg , FILTER excludes rows that do not satisfy its condition, whereas a CASE WHEN expression can contribute NULL placeholders for those rows. However, FILTER does not automatically remove NULL... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/filter.html
- CSV Auto Detection 7684
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...he file in terms of types. For example, in flights.csv , we can see that the header row consists of only VARCHAR columns – whereas the values contain a DATE value for the FlightDate column. As such – the system defines the first row as the header row an... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Versioning of Extensions 7684
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...., version v1.2.3 is older than v1.2.4 ) Give an indication of expected stability (e.g., v0.0.1 is likely not very stable, whereas v13.11.0 probably is stable) Just like DuckDB itself , DuckDB extensions have their own version number. To ensure consiste... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
DuckDB 2.0 Documentation / man.mtool.work