Parent Directory | Revision Log
added attribute to function, fixed warnings, fixed limit and offset
1 | drop type __pgest cascade; |
2 | |
3 | CREATE TYPE __pgest AS ( |
4 | -- id integer, |
5 | id text, |
6 | uri text, |
7 | title text, |
8 | -- size integer |
9 | size text |
10 | ); |
11 | |
12 | -- Search est-e index as table |
13 | -- select * from pgest('/index/path/','query', '@uri ISTREW .txt' limit, offset); |
14 | CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int) |
15 | RETURNS SETOF __pgest |
16 | AS 'pgest', 'pgest' |
17 | LANGUAGE C IMMUTABLE STRICT; |
18 | |
19 | CREATE OR REPLACE FUNCTION pgest2(text[]) |
20 | RETURNS setof record |
21 | AS 'pgest','pgest2' |
22 | LANGUAGE 'C' IMMUTABLE STRICT; |
ViewVC Help | |
Powered by ViewVC 1.1.26 |