--- trunk/test.sql 2005/05/27 12:13:28 24 +++ trunk/test.sql 2005/05/27 21:06:01 25 @@ -5,10 +5,10 @@ --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 * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ; +select substr(uri,45),title,year from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', 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) group by title order by title; +select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null, array['@title']) as (title text) group by title order by title; -- example of new API which allows user to specify attributes 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;