24 |
select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 1, 'blade runner', 'year NUMGT 1990', '@title STRA', 10, 5, array['@title']) as (title text); |
select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 1, 'blade runner', 'year NUMGT 1990', '@title STRA', 10, 5, array['@title']) as (title text); |
25 |
|
|
26 |
-- comparison of direct access and node API |
-- comparison of direct access and node API |
|
|
|
27 |
-- explain analyze select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |
-- explain analyze select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |
28 |
explain analyze select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |
explain analyze select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); |
29 |
|
|
30 |
|
-- example of using convert and hints |
31 |
|
select uri,convert(title,'UTF-8', 'LATIN2') as title,year,hits,wordnum,time |
32 |
|
from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, |
33 |
|
'blade', '@title ISTRINC runner', null, null, null, |
34 |
|
array['@uri','@title','year','HINTS.HIT','HINTS.WORDNUM','HINTS.TIME']) as |
35 |
|
(uri text, title text, year int, hits int, wordnum text, time text); |
36 |
|
|