cockroachdb / cockroachdb/cockroach

sql: support more builtins from postgres

Open
#114,871 0 comments 2 reactions 0 assignees View on GitHub
A-sql-pgcompat C-enhancement O-pg-regress T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

The following is a list of the top postgres builtins that are missing in CRDB, ranked by number of occurrences in pg_regress:

- [ ] 134 pg_input_is_valid()
- [ ] 116 pg_input_error_info()
- [ ] 108 nummultirange()
- [ ] 59 numrange()
- [ ] 45 regexp_matches()
- [ ] 34 pg_get_object_address()
- [ ] 30 to_date()
- [ ] 29 pg_partition_tree()
- [ ] 26 regexp_instr()
- [ ] 23 xmlparse()
- [ ] 22 to_number()
- [ ] 20 pg_size_bytes()
- [ ] 20 brin_summarize_range()
- [ ] 18 xpath()
- [ ] 18 regexp_substr()
- [ ] 18 array_fill()
- [ ] 17 date_bin()
- [ ] 17 brin_desummarize_range()
- [ ] 16 pg_stat_force_next_flush()

Full spreadsheet, which also includes UDFs, is here: https://docs.google.com/spreadsheets/d/1wEB3XeM4H_HUueMphr5pJss8oKQmukni2iIP1Jy56ZA/edit#gid=0

Jira issue: CRDB-33727

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.