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	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	14	-- 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;