--- trunk/test.sql 2005/07/06 14:47:56 31 +++ trunk/test.sql 2005/07/07 17:24:22 37 @@ -5,7 +5,7 @@ --select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0); -- find all references to blade runner in other films -select substr(uri,45),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('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null, null, array['@uri','@title','year']) as (uri text, title text, year int); -- find all references and count them to blade runner after 1990 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;