search

dolthub / doltgresql

DoltgreSQL - Version Controlled PostgreSQL
Apache License 2.0
1.12k stars 25 forks source link

implement `to_char` for timestamp (mostly) #998

Closed jycor closed 6 days ago

jycor commented 1 week ago

This PR adds support for most of the date format specifiers mentioned here: https://www.postgresql.org/docs/current/functions-formatting.html

github-actions[bot] commented 6 days ago
Main PR
covering_index_scan_postgres 433.63/s 435.75/s +0.4%
index_join_postgres 161.68/s 162.60/s +0.5%
index_join_scan_postgres 187.38/s 187.42/s 0.0%
index_scan_postgres 15.06/s 15.15/s +0.5%
oltp_point_select 2875.56/s 2855.17/s -0.8%
oltp_read_only 1934.71/s 1947.04/s +0.6%
select_random_points 121.04/s 119.90/s -1.0%
select_random_ranges 94.27/s 93.06/s -1.3%
table_scan_postgres 14.75/s 14.63/s -0.9%
types_table_scan_postgres 6.93/s 6.84/s -1.3%
github-actions[bot] commented 6 days ago
Main PR
Total 42090 42090
Successful 14534 14534
Failures 27556 27556
Partial Successes[^1] 4689 4689
Main PR
Successful 34.5308% 34.5308%
Failures 65.4692% 65.4692%

[^1]: These are tests that we're marking as Successful, however they do not match the expected output in some way. This is due to small differences, such as different wording on the error messages, or the column names being incorrect while the data itself is correct.