Array to IN operator within Database
Scenario:
We are querying a table in Postgresql and retrieving records with ID.
The query output is similar to this:
[
{
"record_id": [
403,
412,
414
]
}
...
Forum Discussion
Hey @rajendraj
Why do you map(x => parseInt(x)) when you don’t need to. Simply go with join(“,”). Next, when you obtain the output you shouldn’t have something like ‘(403,412,414)’ but just without the single quotes, i.e. (403,412,414).
Actually the single quotes are erroring out.
I made a test pipeline for updating in Postgres, which you can take a look:
PostgreSQL update example_2020_07_06.slp (4.8 KB)
BR, Igor Micev
Igor,
Thanks for the solution. After I posted the question, I did solve by doing join but used ANY operator provided by Postgresql which made it much more simpler to solve in my case. Thanks once again though.
