Skip to content

Keyword completion: Inquire pg_catalog.pg_proc table for scalar functions #401

@amotl

Description

@amotl

About

CrateDB offers a PostgreSQL-compatible pg_catalog.pg_proc database system table. It could be used to inquire all scalar function symbols, to add them to the list of keywords provided by the crate.crash.repl.SQLCompleter, similar to how the pg_catalog.pg_get_keywords() function is used to inquire the list of non-function keywords.

Outlook

At GH-360, we also reported:

Some scalar functions like floor or ceil are included within the documentation, but are not part of either pg_catalog.pg_get_keywords() nor the list of fallback keywords [4].
[4] https://github.com/crate/crash/blob/0.27.0/crate/crash/repl.py#L115-L151

In this spirit, other than using pg_catalog.pg_proc, the list of "fallback keywords", or maybe a list of "additional keywords", would probably still need to be maintained, in order to accompany for any gaps.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions