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

From Francisco Olarte
Subject Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1
Date
Msg-id CA+bJJbx=CM8zzmBSgOwUvfJsQqKrHKb1ohATcAxC4s_rvkaJMA@mail.gmail.com
Whole thread Raw
In response to Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Alexander:

On Fri, Aug 12, 2016 at 11:00 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:
> 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:

This I know, I wasn't trying to solve the problem. I was just trying
to point that "select" is not the same in plpgsql and in sql, so you
need to read the docs for plpgsql to find how to solve it.

Francisco Olarte.


pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1
Next
From: Chris Travers
Date:
Subject: Re: Postgres Pain Points 2 ruby / node language drivers