Re: store multiple rows with the SELECT INTO statement

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Janek Sendrowski <janek12(at)web(dot)de>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: store multiple rows with the SELECT INTO statement
Date: 2013-09-04 02:12:56
Message-ID: 52269728.6030602@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Van Dyk 2013-09-04 05:24:19 Re: uuids with btree_gist
Previous Message Jeff Janes 2013-09-04 02:10:49 Re: Generic function for partitioning function?