pgestraier/trunk/pgest.sql


-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
CREATE OR REPLACE FUNCTION pgest(text, text, text, text, int, int, text[])
        RETURNS setof record
        AS 'pgest','pgest_attr'
        LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;

-- select * from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', depth, 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, text, text, text, int, int, text[])
        RETURNS setof record
        AS 'pgest','pgest_node'
        LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;

-- trigger for insert/update or delete
CREATE OR REPLACE FUNCTION pgest_trigger() RETURNS TRIGGER
        AS 'pgest', 'pgest_trigger'
        LANGUAGE 'C' STRICT;

1	dpavlin	1
2	dpavlin	31	-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
3			CREATE OR REPLACE FUNCTION pgest(text, text, text, text, int, int, text[])
4	dpavlin	19	RETURNS setof record
5			AS 'pgest','pgest_attr'
6			LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
7	dpavlin	25
8	dpavlin	49	-- select * from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', depth, 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
9			CREATE OR REPLACE FUNCTION pgest(text, text, text, int, text, text, text, int, int, text[])
10	dpavlin	41	RETURNS setof record
11			AS 'pgest','pgest_node'
12			LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
13	dpavlin	61
14			-- trigger for insert/update or delete
15			CREATE OR REPLACE FUNCTION pgest_trigger() RETURNS TRIGGER
16			AS 'pgest', 'pgest_trigger'
17			LANGUAGE 'C' STRICT;
18