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

How do we add support for the postgres OVERLAPS operation? #294

Open
bneigher opened this issue Jan 18, 2023 · 1 comment
Open

How do we add support for the postgres OVERLAPS operation? #294

bneigher opened this issue Jan 18, 2023 · 1 comment

Comments

@bneigher
Copy link

bneigher commented Jan 18, 2023

Hello -- absolutely LOVE this library. We've completely built our unit and e2e testing around it and it is super slick.

I had a question regarding supporting an operator: OVERLAPS which appears to not be supported:

SELECT (
  timestamp '2022-11-23 03:00:00.362+00', timestamp '2022-11-24 03:00:00.362+00'
) OVERLAPS (
  timestamp '2022-11-24 03:00:00.362+00', timestamp '2022-11-25 03:00:00.362+00'
);

I am unable to perform this kind of query.. getting the following error message:

'Unexpected kw_overlaps token: "overlaps". Instead, I was expecting to see one of the following:\n' +
          '\n' +
          '    - A "op_cast" token\n' +
          '    - A "lbracket" token\n' +
          '    - A "kw_is" token\n' +
          '    - A "kw_notnull" token\n' +
          '    - A "kw_is" token\n' +
          '    - A "kw_isnull" token\n' +

It looks like OVERLAPS is not supported.. can I add this in using registerOperator or registerFunction? I believe this is the only thing not supported in my entire API.

@bneigher
Copy link
Author

bneigher commented Feb 5, 2023

#298

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant