Search Postgresql Archives

Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Francisco, thanks, but -
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;

Regards
Alex

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux