I am also working on a full text search system, and I have a similar
problem, although I can get around the full table scan if I can simply
return a full set of tuples.
select * from table where table.key in ( function('bla bla bla') );
Or
create table result as function('bla bla bla');
selec
Dear Hackers,
While working on a postgres-based fulltext searching system
we encountered the following problem:
There is a table
create table t (
x int []
)
and a given integer constant y.
The task is to find those records of this table, which contain the
value y in the arrays
