0

I've been trying to get plv8 working on PostgreSQL 10 (completely clean install, never used it before). I've created a function like so:

CREATE OR REPLACE FUNCTION FindActivitiesJS(_id integer)
  RETURNS Text AS
  $BODY$
  var queryResult = plv8.execute('SELECT * FROM activities WHERE activityid = $1', [_id]);
  return JSON.stringify(queryResult);
  $BODY$
  LANGUAGE plv8 VOLATILE;

When I run:

select * from findactivitiesjs(3)

I get:

ERROR: Error: there is no parameter $0 DETAIL: findactivitiesjs() LINE 2: var queryResult = plv8.execute('SELECT * FROM activities WHERE activityid = SQL state: XX000

I've also tried changing the SQL query to SELECT * FROM activities WHERE activityid = $0 but same results. It's something about the parameter on the query, since a SELECT statement with no WHERE clause works fine.

What am doing wrong?

Mike Christensen
  • 88,082
  • 50
  • 208
  • 326

0 Answers0