Francisco, thanks, but -
On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote:
https://www.postgresql.org/docs/9.5/static/plpgsql- statements.html#PLPGSQL- STATEMENTS-SQL-ONEROW
but the custom function I am trying to call (from another function) does not return one row, but several rows, which I'd like to store into a temp table:
SELECT
out_word AS word,
max(out_score) AS score
INTO TEMP TABLE _words ON COMMIT DROP
FROM check_words(in_uid, in_gid, in_tiles)
GROUP BY word, gid;
SELECT
out_word AS word,
max(out_score) AS score
INTO TEMP TABLE _words ON COMMIT DROP
FROM check_words(in_uid, in_gid, in_tiles)
GROUP BY word, gid;
Regards
Alex
