Function createSearchFunctionQuery

packages/node-core/src/db/sync-helper.ts:744–754

(schema: string, table: string)

export const dropSearchFunctionQuery = (schema: string, table: string): string =>
  dropFunction(schema, searchFunctionName(schema, table));
export const createSearchFunctionQuery = (schema: string, table: string): string => {
  const functionName = searchFunctionName(schema, table);
  return `
create or replace function ${escapedName(schema, functionName)}(search text)
  returns setof ${escapedName(schema, table)} as $$
    select *
    from ${escapedName(schema, table)} as "table"
    where "table"."${TS_VECTOR_COL}" @@ to_tsquery(search)
  $$ language sql stable;
  `;
};

export const commentSearchFunctionQuery = (schema: string, table: string): Query =>
  commentOnFunction(schema, searchFunctionName(schema, table), `@name search_${table}`);