| 1 |
1 |
dpavlin |
|
| 2 |
31 |
dpavlin |
-- select * from pgest('/index/path', 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text); |
| 3 |
|
|
CREATE OR REPLACE FUNCTION pgest(text, text, text, text, int, int, text[]) |
| 4 |
19 |
dpavlin |
RETURNS setof record |
| 5 |
|
|
AS 'pgest','pgest_attr' |
| 6 |
|
|
LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT; |
| 7 |
25 |
dpavlin |
|
| 8 |
49 |
dpavlin |
-- 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); |
| 9 |
|
|
CREATE OR REPLACE FUNCTION pgest(text, text, text, int, text, text, text, int, int, text[]) |
| 10 |
41 |
dpavlin |
RETURNS setof record |
| 11 |
|
|
AS 'pgest','pgest_node' |
| 12 |
|
|
LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT; |
| 13 |
61 |
dpavlin |
|
| 14 |
|
|
-- trigger for insert/update or delete |
| 15 |
|
|
CREATE OR REPLACE FUNCTION pgest_trigger() RETURNS TRIGGER |
| 16 |
|
|
AS 'pgest', 'pgest_trigger' |
| 17 |
|
|
LANGUAGE 'C' STRICT; |
| 18 |
|
|
|