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	dpavlin	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	dpavlin	19	-- select * from pgest('/index/path','query', '@uri ISTREW .txt', limit, offset);
14	dpavlin	5	CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)
15	dpavlin	1	RETURNS SETOF __pgest
16			AS 'pgest', 'pgest'
17	dpavlin	19	LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
18	dpavlin	1
19	dpavlin	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;