pgestraier/trunk/pgest.sql

drop type __pgest cascade;

CREATE TYPE __pgest AS (
--      id integer,
        id text,
        uri text,
        title text,
--      size integer
        size text
);

-- Search est-e index as table
-- select * from pgest('/index/path','query', '@uri ISTREW .txt', limit, offset);
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)
        RETURNS SETOF __pgest
        AS 'pgest', 'pgest'
        LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;

-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text);
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[])
        RETURNS setof record
        AS 'pgest','pgest_attr'
        LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
1	drop type __pgest cascade;
2
3	CREATE TYPE __pgest AS (
4	-- id integer,
5	id text,
6	uri text,
7	title text,
8	-- size integer
9	size text
10	);
11
12	-- Search est-e index as table
13	-- select * from pgest('/index/path','query', '@uri ISTREW .txt', limit, offset);
14	CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)
15	RETURNS SETOF __pgest
16	AS 'pgest', 'pgest'
17	LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
18
19	-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text);
20	CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[])
21	RETURNS setof record
22	AS 'pgest','pgest_attr'
23	LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;