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', limit, offset);
CREATE OR REPLACE FUNCTION pgest(text, text, int, int)
        RETURNS SETOF __pgest
        AS 'pgest', 'pgest'
        LANGUAGE C IMMUTABLE STRICT;

CREATE OR REPLACE FUNCTION pgest2(text[])
RETURNS setof record
AS 'pgest','pgest2'
LANGUAGE 'C' IMMUTABLE STRICT;
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	3	-- select * from pgest('/index/path/','query', limit, offset);
14			CREATE OR REPLACE FUNCTION pgest(text, text, int, int)
15	dpavlin	1	RETURNS SETOF __pgest
16			AS 'pgest', 'pgest'
17			LANGUAGE C IMMUTABLE STRICT;
18
19			CREATE OR REPLACE FUNCTION pgest2(text[])
20			RETURNS setof record
21			AS 'pgest','pgest2'
22			LANGUAGE 'C' IMMUTABLE STRICT;