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 |
-- example of using convert and hints |
31 |
select uri,convert(title,'UTF-8', 'LATIN2'),year from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', '@title !ISTRINC blade runner', null, null, null, array['@uri','@title','year']) as (uri text, title text, year int); |
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 |
|
|