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;

CREATE OR REPLACE FUNCTION pgest2(text[])
RETURNS setof record
AS 'pgest','pgest2'
LANGUAGE 'C' IMMUTABLE STRICT;
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	CREATE OR REPLACE FUNCTION pgest2(text[])
20	RETURNS setof record
21	AS 'pgest','pgest2'
22	LANGUAGE 'C' IMMUTABLE STRICT;