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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1
Дата
Msg-id CAMsr+YGhwo_RFOZvaMOgPoWc2oF-1qUo-No=jYA7O8n23iLzeg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Alexander Farber <alexander.farber@gmail.com>)
Ответы Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Alexander Farber <alexander.farber@gmail.com>)
Список pgsql-general
On 12 August 2016 at 18:43, Alexander Farber <alexander.farber@gmail.com> wrote:
Thank you,  I have rewritten it into:

BEGIN
        PERFORM check_positions(in_uid, in_gid, in_tiles);

        CREATE TEMP TABLE _words(word varchar, score integer) ON COMMIT DROP;

        INSERT INTO _words
        SELECT
                out_word AS word,
                max(out_score) AS score
        FROM check_words(in_uid, in_gid, in_tiles)
        GROUP BY word, gid;


Or use CREATE TABLE ... AS SELECT ... 

That's the SQL-standard spelling anyway. 


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

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