--- trunk/test.sql 2005/05/26 00:16:48 16 +++ trunk/test.sql 2005/05/26 13:57:32 17 @@ -10,3 +10,6 @@ -- find all references to blade runner in other films select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ; + +-- find all references and count them to blade runner after 1990 +select count(title),title from pgest('/home/dpavlin/pgestraier/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title;