/[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 23 by dpavlin, Thu May 26 20:22:44 2005 UTC revision 24 by dpavlin, Fri May 27 12:13:28 2005 UTC
# Line 8  Line 8 
8  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) ;
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##/pgestraier/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title;  select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null) 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, array['@title','year']) as (title text, year text) group by year order by year asc;  select count(title),year from pgest('##dir##/data/casket', 'blade runner', null, null, null, array['@title','year']) as (title text, year text) group by year order by year asc;
Legend:
Removed from v.23  
changed lines
  Added in v.24
  ViewVC Help
Powered by ViewVC 1.1.26