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	drop type __pgswish cascade;
2
3	CREATE TYPE __pgswish AS (
4	rank integer,
5	path text,
6	headline text,
7	size integer
8	);
9
10	-- Search swish-e index as table
11	-- select * from pgswish('/index/path/','query', 'sort');
12	CREATE OR REPLACE FUNCTION pgswish(text, text, text)
13	RETURNS SETOF __pgswish
14	AS 'pgswish', 'pgswish'
15	LANGUAGE C IMMUTABLE STRICT;
16
17	-- 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;