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