Timeline for How to get exact match when the column used for filtering is comma-separated list in postgresql
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 19, 2023 at 14:45 | comment | added | user1822 | Well, if it's the output of a query, then you won't be able to create an index for that. But maybe it makes more sense to filter those values in that query instead of afterwards | |
| Jan 19, 2023 at 14:33 | comment | added | Ross | Actually the table is not the direct table in DB. Its the output of another common function which is used for further calculation. Thanks for bringing up the concept of array to use here. Researched further on this and used && instead of @> which suits more for the requirement. | |
| Jan 19, 2023 at 9:24 | history | answered | user1822 | CC BY-SA 4.0 |