plv8 query example with IN operator

Question

I am having trouble executing this query

var insurers = [];  
var valid_insurer_query = plv8.execute('select * from table_name where row_id IN $1', [insurers])

It is giving syntax error

Error: syntax error at or near "$1"

It works fine if I use the query

var valid_insurer_query = plv8.execute('select * from table_name where row_id = $1', [insurer])  // here insurer is some entry from insurers.

I think it is creating trouble because psql query is unable to use javascript array as list. But I don't know how can I fix this issue ? Can anyone suggest some solution ? Can anyone share an example on how to use IN query in plv8 ?

You already seem to know the answer. Why don't you use the one that works? — jjanes
– jjanes, Commented May 15, 2020 at 16:57
Both of the statements have different purpose. Second one doesn't solve my purpose. I need to get the rows for which row_id is in the list. — S.K
– S.K, Commented May 16, 2020 at 5:48
Sorry, I somehow read your 2nd one as =ANY($1) rather than =$1 — jjanes
– jjanes, Commented May 16, 2020 at 14:03

jjanes · Accepted Answer · 2020-05-15 16:56:22Z

1

I don't use plv8, but IN works with lists and lists can't be stored in parameters. What you appear to have is an array. For arrays, you use:

=ANY($1)

answered May 15, 2020 at 16:56

jjanes

45k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

plv8 query example with IN operator

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related