How do I call pgroonga query in rpc

[minosss]

function

CREATE OR REPLACE FUNCTION search_books(
  keywords text
) RETURNS SETOF books AS $$
BEGIN
  IF keywords IS NULL OR keywords = '' THEN
    RETURN QUERY SELECT * from books;
  ELSE
    RETURN QUERY SELECT * from books WHERE name &@~ keywords;
  END IF;
END;
$$ LANGUAGE plpgsql;

It works in sql editor like select * search_books('abc').

When using the client, the call failed.

client.rpc('search_books', { keywords: '' }); // OK
client.rpc('search_books', { keywords: 'abc' }); // FAIL

{
  code: '42883',
  details: null,
  hint: 'No operator matches the given name and argument types. You might need to add explicit type casts.',
  message: 'operator does not exist: text &@~ text'
}

[wolfgangwalther]

You probably need to do either:

• add the schema in which the pgroonga operator is placed to db-extra-search-path
• schema qualify the operator with OPERATOR(<pgroonga schem>.&@~)

[minosss]

Thanks.

-- current
show search_path;
-- .. extensions
-- pgroonga is installed by default in extensions

-- works
RETURN QUERY SELECT * from books WHERE name OPERATOR(extensions.&@~) keywords;