/[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 49 by dpavlin, Sat Oct 29 18:54:40 2005 UTC revision 51 by dpavlin, Tue May 9 22:55:42 2006 UTC
# Line 5  Line 5 
5  --select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0);  --select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0);
6    
7  -- find all references to blade runner in other films  -- find all references to blade runner in other films
8  select uri,title,year from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null, null, array['@uri','@title','year']) as (uri text, title text, year int);  select uri,title,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);
9    
10  -- find all references and count them to blade runner after 1990  -- find all references and count them to blade runner after 1990
11  select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null, null, array['@title']) as (title text) group by title order by title;  select count(title),title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', 'year NUMGT 1990', null, null, null, array['@title']) as (title text) group by title order by title;
12    
13  -- example of new API which allows user to specify attributes  -- example of new API which allows user to specify attributes
14  select count(title),year from pgest('##dir##/data/casket', 'blade runner', null, null, null, null, array['@title','year']) as (title text, year text) group by year order by year asc;  select count(title),year from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', null, null, null, null, array['@title','year']) as (title text, year text) group by year order by year asc;
15    
16  -- test sort order  -- test sort order
17  select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);  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);
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('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', 'year NUMGT 1990{{!}}@title ISTRINC blade', null, null, null, array['@title']) as (title text);
21    
22  -- node API examples  -- node API examples
23    
24  select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 1, 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, 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    
28  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);
29  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);
Legend:
Removed from v.49  
changed lines
  Added in v.51
  ViewVC Help
Powered by ViewVC 1.1.26