Re: store multiple rows with the SELECT INTO statement - Mailing list pgsql-general

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.klaver@gmail.com