Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1 - Mailing list pgsql-general

From Alexander Farber
Subject Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1
Date
Msg-id CAADeyWim8aiW9RJ3JynB4wU3vjGizKEGSpZJUvZ386NcUMqz9g@mail.gmail.com
Whole thread Raw
In response to Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-general
Tree view
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;

Regards
Alex

pgsql-general by date:

Previous
From: "Karsten Hilbert"
Date:
Subject: Re: Postgres Pain Points 2 ruby / node language drivers
Next
From: Craig Ringer
Date:
Subject: Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1