--- trunk/pgest.sql 2005/05/26 17:56:53 19 +++ trunk/pgest.sql 2005/05/27 21:06:01 25 @@ -1,23 +1,7 @@ -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; - --- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text); +-- 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; +