pgestraier/trunk/pgest.sql


-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, ARRAY['@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
2	-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
3	CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[])
4	RETURNS setof record
5	AS 'pgest','pgest_attr'
6	LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
7