PTT search_engine

search_engine.sql

CREATE OR REPLACE FUNCTION search_engine(_words varchar) 
RETURNS  table (oid int) AS
$BODY$ 
declare _words_len int;_arrwords varchar[];
begin 
	select regexp_split_to_array(_words,'[ ,-.~\+]+') into _arrwords;
	select array_length(_arrwords,1) into _words_len;
	return query
	select d.oid from token t,dupindex d,vd_ptt_post p
	where t.words in (select unnest(_arrwords)) 
	and d.tid=t.tid and p.oid=d.oid
	group by d.oid having count(*)=_words_len;
end; 
$BODY$
  LANGUAGE plpgsql;