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, May 15 '20 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, May 16 '20 at 05:48
Sorry, I somehow read your 2nd one as `=ANY($1)` rather than =$1 — jjanes, May 16 '20 at 14:03

score 1 · Accepted Answer · answered May 15 '20 at 16:56

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 '20 at 16:56

jjanes

37,812
5
27
34

plv8 query example with IN operator

1 Answers1