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;

-- get property value while retriving results with pgswish
-- select *,pgtextprop('property') from pgswish(...) ...

CREATE OR REPLACE FUNCTION swtextprop(text)
        RETURNS text
        AS 'pgswish', 'swtextprop'
        LANGUAGE C STRICT;
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	-- get property value while retriving results with pgswish
18	-- select *,pgtextprop('property') from pgswish(...) ...
19
20	CREATE OR REPLACE FUNCTION swtextprop(text)
21	RETURNS text
22	AS 'pgswish', 'swtextprop'
23	LANGUAGE C STRICT;