/[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 13 by dpavlin, Thu May 26 00:05:33 2005 UTC revision 37 by dpavlin, Thu Jul 7 17:24:22 2005 UTC
# Line 1  Line 1 
1  select * from pgest(null, 'a OR b OR c', '', 0, 0);  --select * from pgest(null, 'a OR b OR c', '', 0, 0);
2  select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 0, 10);  --select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 0, 10);
3  select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 20, 0);  --select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 20, 0);
4  select * from pgest('##dir##/data/casket', 'a OR b OR c', null, 20, 0);  --select * from pgest('##dir##/data/casket', 'a OR b OR c', null, 20, 0);
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);
 select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 10, 1);  
 --select * from pgest2('{foo}') as (a text, b text) ;  
 --select * from pgest2('{foo}') as (a text, b text, c text) ;  
 --select * from pgest2('{foo}') as (a text, b text, c text, d text) ;  
6    
7  -- find all references to blade runner in other films  -- find all references to blade runner in other films
8  select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ;  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);
9    
10    -- 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;
12    
13    -- 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;
15    
16    -- 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);
18    
Legend:
Removed from v.13  
changed lines
  Added in v.37
  ViewVC Help
Powered by ViewVC 1.1.26