search

crate / crate

CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
https://cratedb.com/product
Apache License 2.0
4.06k stars 555 forks source link

Type precedence overview page #11259

Closed joemoe closed 1 week ago

joemoe commented 4 years ago

Pitch

Use case:

The documentation is referring to type precedence in some cases, but we never make it explicit. For users to understand what is happening it would be helpful if we could point them to a list.

Feature description:

Microsoft has a nice overview page for its database products. Something like this in our documentation would be sufficient I guess. https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-type-precedence-transact-sql?view=sql-server-ver15

mfussenegger commented 4 years ago

For whoever wants to pick this up and write the docs for it - the current precedence is defined here:

https://github.com/crate/crate/blob/c8c0c569fd64b721a5a24a4e29b3bb1046a08479/server/src/main/java/io/crate/types/DataType.java#L36-L73