gistfile1.sql

SELECT distinct on (documents.id) documents.* 
FROM "documents" 
WHERE (documents.id in (
      (select document_id from metadata where 
          (metadata.kind = E'person' and 
           to_tsvector('english', metadata.value) @@ plainto_tsquery(E'bush'))) 
      intersect 
      (select document_id from metadata where 
        (metadata.kind = E'city' and 
         to_tsvector('english', metadata.value) @@ plainto_tsquery(E'washington'))))) 

LIMIT 10 OFFSET 0