Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Gist index ops #341

Closed
wangjie-star opened this issue Aug 1, 2023 · 0 comments
Closed

Support Gist index ops #341

wangjie-star opened this issue Aug 1, 2023 · 0 comments
Assignees
Labels
3.0 enhancement New feature or request

Comments

@wangjie-star
Copy link
Collaborator

wangjie-star commented Aug 1, 2023

Enhancement

If the PG data type corresponding to the compatible Oracle data type supports Gist index or GIN index, these Oracle data types should also support the corresponding index operator.
The indexing operators that should be supported are as follows:

oprname oprleft oprright
< number number
<= number number
= number number
>= number number
> number number
<> number number

The above is the Gist index operator of the "number" data type to be implemented.

oprname oprleft oprright
< varchar2 varchar2
<= varchar2 varchar2
= varchar2 varchar2
>= varchar2 varchar2
> varchar2 varchar2
<> varchar2 varchar2

The above is the Gist index operator of the "varchar2" data type to be implemented.

oprname oprleft oprright
< binary_float binary_float
<= binary_float binary_float
= binary_float binary_float
>= binary_float binary_float
> binary_float binary_float
<> binary_float binary_float
<-> binary_float binary_float

The above is the Gist index operator of the "binary_float" data type to be implemented.

oprname oprleft oprright
< binary_double binary_double
<= binary_double binary_double
= binary_double binary_double
>= binary_double binary_double
> binary_double binary_double
<> binary_double binary_double
<-> binary_double binary_double

The above is the Gist index operator of the "binary_double" data type to be implemented.

oprname oprleft oprright
< date date
<= date date
= date date
>= date date
> date date
<> date date
<-> date date

The above is the Gist index operator of the "date" data type to be implemented.

oprname oprleft oprright
< timestamp timestamp
<= timestamp timestamp
= timestamp timestamp
>= timestamp timestamp
> timestamp timestamp
<> timestamp timestamp
<-> timestamp timestamp

The above is the Gist index operator of the "timestamp" data type to be implemented.

oprname oprleft oprright
< timestamp with time zone timestamp with time zone
<= timestamp with time zone timestamp with time zone
= timestamp with time zone timestamp with time zone
>= timestamp with time zone timestamp with time zone
> timestamp with time zone timestamp with time zone
<> timestamp with time zone timestamp with time zone
<-> timestamp with time zone timestamp with time zone

The above is the Gist index operator of the "timestamp with time zone" data type to be implemented.

oprname oprleft oprright
< timestamp with local time zone timestamp with local time zone
<= timestamp with local time zone timestamp with local time zone
= timestamp with local time zone timestamp with local time zone
>= timestamp with local time zone timestamp with local time zone
> timestamp with local time zone timestamp with local time zone
<> timestamp with local time zone timestamp with local time zone
<-> timestamp with local time zone timestamp with local time zone

The above is the Gist index operator of the "timestamp with local time zone" data type to be implemented.

oprname oprleft oprright
< interval year to month interval year to month
<= interval year to month interval year to month
= interval year to month interval year to month
>= interval year to month interval year to month
> interval year to month interval year to month
<> interval year to month interval year to month
<-> interval year to month interval year to month

The above is the Gist index operator of the "interval year to month" data type to be implemented.

oprname oprleft oprright
< interval day to second interval day to second
<= interval day to second interval day to second
= interval day to second interval day to second
>= interval day to second interval day to second
> interval day to second interval day to second
<> interval day to second interval day to second
<-> interval day to second interval day to second

The above is the Gist index operator of the "interval day to second" data type to be implemented.

@wangjie-star wangjie-star added the enhancement New feature or request label Aug 1, 2023
@wangjie-star wangjie-star self-assigned this Aug 1, 2023
@tanyang-star tanyang-star changed the title Support Gist/GIN index ops Support Gist index ops Aug 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
3.0 enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants