/[pgestraier]/trunk/test.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/test.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 56 by dpavlin, Thu May 11 15:52:50 2006 UTC revision 57 by dpavlin, Thu May 11 16:19:38 2006 UTC
# Line 27  select title from pgest('http://localhos Line 27  select title from pgest('http://localhos
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, 5, 0, array['@uri','@title','year']) as (uri text, title text, year int);  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);
Legend:
Removed from v.56  
changed lines
  Added in v.57
  ViewVC Help
Powered by ViewVC 1.1.26