On 09/03/2013 04:34 PM, Janek Sendrowski wrote:
> A loop through every input sentence
> FOR i IN 1..array_length(p_sentence, 1) LOOP
> FOR some_rec IN EXECUTE "SELECT * FROM table WHERE "Fulltextsearch
> statement" LOOP
> "Insert the current record data into the temp table"
> END LOOP;
> END LOOP;
> Do a next query on the table
Forgot to mention the FOREACH loop is in Postgres 9.1+
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com