search

kwilteam / docs

5 stars 6 forks source link

Change documentation of type cast precedence #133

Open brennanjl opened 4 weeks ago

brennanjl commented 4 weeks ago

Our Kuneiform documentation document type casting (::) as an expression that has operator precedence. However, Kuneiform actually treats it as an optional addition to certain expressions that are typecastable.

We should remove it as an expression, and instead add another column that indicates whether each expression can be type casted.

brennanjl commented 4 weeks ago

We should also update our link to Postgres's docs from 7.2 to https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-PRECEDENCE, and include the missing operators (e.g. collate).

brennanjl commented 4 weeks ago

I have changed the operator precedence in Kuneiform to mostly match Postgres 16. We should make sure to update our table's order according to the grammar files