10 |
); |
); |
11 |
|
|
12 |
-- Search est-e index as table |
-- Search est-e index as table |
13 |
-- select * from pgest('/index/path/','query', '@uri ISTREW .txt' limit, offset); |
-- select * from pgest('/index/path','query', '@uri ISTREW .txt', limit, offset); |
14 |
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int) |
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int) |
15 |
RETURNS SETOF __pgest |
RETURNS SETOF __pgest |
16 |
AS 'pgest', 'pgest' |
AS 'pgest', 'pgest' |
17 |
LANGUAGE C IMMUTABLE CALLED ON NULL INPUT; |
LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT; |
18 |
|
|
19 |
CREATE OR REPLACE FUNCTION pgest2(text[]) |
-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text); |
20 |
RETURNS setof record |
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[]) |
21 |
AS 'pgest','pgest2' |
RETURNS setof record |
22 |
LANGUAGE 'C' IMMUTABLE STRICT; |
AS 'pgest','pgest_attr' |
23 |
|
LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT; |