18 |
|
|
19 |
-- test attributes delimited by {{!}} |
-- test attributes delimited by {{!}} |
20 |
select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990{{!}}@title ISTRINC blade', null, null, null, array['@title']) as (title text); |
select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990{{!}}@title ISTRINC blade', null, null, null, array['@title']) as (title text); |
21 |
|
|
22 |
|
-- node API examples |
23 |
|
|
24 |
|
select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |
25 |
|
|
26 |
|
-- comparison of direct access and node API |
27 |
|
|
28 |
|
explain analyze select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |
29 |
|
explain analyze select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |