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

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1
Дата
Msg-id CAADeyWgZ=KLQGXfhU6xEa-F8FPUQutQR_xdkALmyDMcm+VP_rg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Francisco Olarte <folarte@peoplecall.com>)
Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Postgres Pain Points 2 ruby / node language drivers
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1