--- trunk/test.sql 2006/05/11 15:52:50 56 +++ trunk/test.sql 2006/05/11 16:19:38 57 @@ -27,5 +27,5 @@ -- 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('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text); --- example of using convert -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, 5, 0, array['@uri','@title','year']) as (uri text, title text, year int); +-- example of using convert and hints +select uri,convert(title,'UTF-8', 'LATIN2'),year,hits,h1,h2 from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', '@title !ISTRINC blade runner', null, 5, 0, array['@uri','@title','year','HINTS.HIT','HINTS.WORDNUM','HINTS.TIME']) as (uri text, title text, year int, hits int, h1 text, h2 text);