-- 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;