/[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 17 by dpavlin, Thu May 26 13:57:32 2005 UTC
# Line 10  select * from pgest('##dir##/data/casket Line 10  select * from pgest('##dir##/data/casket
10    
11  -- find all references to blade runner in other films  -- find all references to blade runner in other films
12  select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ;  select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ;
13    
14    -- find all references and count them to blade runner after 1990
15    select count(title),title from pgest('/home/dpavlin/pgestraier/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title;
Legend:
Removed from v.13  
changed lines
  Added in v.17
  ViewVC Help
Powered by ViewVC 1.1.26