t1.txt

text/plain

Download

psql bookfind3 -c "drop table tt;"
psql bookfind3 -c "select id into tt from fti_author where string ~ '^arthur';"
psql bookfind3 -c "create index tti on tt(id);"
psql bookfind3 -c "select count(tt.id) from tt,fti_author a where tt.id=a.id and a.string ~'^clarke';"