Support array comparisons #23

Open
opened 2026-02-16 05:16:07 -05:00 by yindo · 1 comment
Owner

Originally created by @eyurtsev on GitHub (Jun 10, 2024).

Define filters and semantics for array comparisons.

Feel free to use this PR as reference: https://github.com/langchain-ai/langchain-postgres/pull/59

Array comparisons may involve an either "all" or "any" condition.

Requirements

  • Define a clear API to allow swapping between all vs. any
  • Do not break existing ability to do a membership check with in

Only pick up work on this if you have and use postgresql

Originally created by @eyurtsev on GitHub (Jun 10, 2024). Define filters and semantics for array comparisons. Feel free to use this PR as reference: https://github.com/langchain-ai/langchain-postgres/pull/59 Array comparisons may involve an either "all" or "any" condition. # Requirements - Define a clear API to allow swapping between `all` vs. `any` - Do not break existing ability to do a membership check with `in` --- Only pick up work on this if you have and use postgresql
yindo added the help wanted label 2026-02-16 05:16:07 -05:00
Author
Owner

@jernkuan commented on GitHub (Jun 24, 2024):

Hi @eyurtsev

Made another pull request https://github.com/langchain-ai/langchain-postgres/pull/77 that would support both int, float, text.

Not the most optimal, but with postgresql even using raw sql statement i'm not sure whether there is a better way, since ?| support only an array of text and not numbers.

Also added support to run this on windows, as ProacatorEventLoop is not support on windows.

@jernkuan commented on GitHub (Jun 24, 2024): Hi @eyurtsev Made another pull request https://github.com/langchain-ai/langchain-postgres/pull/77 that would support both int, float, text. Not the most optimal, but with postgresql even using raw sql statement i'm not sure whether there is a better way, since ?| support only an array of text and not numbers. Also added support to run this on windows, as ProacatorEventLoop is not support on windows.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langchain-ai/langchain-postgres#23