pgswish/trunk/pgswish.sql

drop type __pgswish cascade;

CREATE TYPE __pgswish AS (
        rank integer,
        path text,
        headline text,
        size integer
);

-- Search swish-e index as table
-- select * from pgswish('/index/path/','query', 'sort');
CREATE OR REPLACE FUNCTION pgswish(text, text, text)
        RETURNS SETOF __pgswish
        AS 'pgswish', 'pgswish'
        LANGUAGE C IMMUTABLE STRICT;

-- select * from pgswish_arr('/index/path', 'query', 'placeholder', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
CREATE OR REPLACE FUNCTION pgswish(text, text, text, int, int, text[])
        RETURNS setof record
        AS 'pgswish','pgswish_arr'
        LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
1	dpavlin	8	drop type __pgswish cascade;
2
3			CREATE TYPE __pgswish AS (
4	dpavlin	13	rank integer,
5	dpavlin	8	path text,
6			headline text,
7	dpavlin	13	size integer
8	dpavlin	8	);
9
10	dpavlin	14	-- Search swish-e index as table
11			-- select * from pgswish('/index/path/','query', 'sort');
12			CREATE OR REPLACE FUNCTION pgswish(text, text, text)
13	dpavlin	8	RETURNS SETOF __pgswish
14			AS 'pgswish', 'pgswish'
15			LANGUAGE C IMMUTABLE STRICT;
16
17	dpavlin	22	-- select * from pgswish_arr('/index/path', 'query', 'placeholder', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
18			CREATE OR REPLACE FUNCTION pgswish(text, text, text, int, int, text[])
19			RETURNS setof record
20			AS 'pgswish','pgswish_arr'
21			LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;