search.sql

-- FUNCTION: api.search_job(character varying, integer, integer, integer)

-- DROP FUNCTION api.search_job(character varying, integer, integer, integer);

CREATE OR REPLACE FUNCTION api.search_job(
	keyword character varying,
	rategt integer,
	ratelt integer,
	session integer)
    RETURNS api.job
    LANGUAGE 'sql'

    COST 100
    STABLE SECURITY DEFINER 
AS $BODY$
  SELECT * FROM api.job
  WHERE 
    (title LIKE '%' || keyword || '%' or text LIKE '%'|| keyword ||'%') and
    session = session and
    rate >= rateGt and
    rate <= rateLt and 
    status = 'active';
$BODY$;

ALTER FUNCTION api.search_job(character varying, integer, integer, integer)
    OWNER TO postgres;