Postgres Pro
Downloads
Home   >   mailing lists

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+bJJbxexatxrEaALKV0Dd5vqUC-VuWvQ7FgP0hG1-1y+j6UTg@mail.gmail.com
Whole thread Raw
In response to SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
On Fri, Aug 12, 2016 at 10:41 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:
> why does this syntax fail in 9.5.3 please?

Maybe because.......

> $func$ LANGUAGE plpgsql;

... you are writing pspgsql.....

> The doc https://www.postgresql.org/docs/9.5/static/sql-selectinto.html just

But are looking at the docs for SQL. This kind of languages are
similar to SQL, but not the same. I think

https://www.postgresql.org/docs/9.5/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW

is the proper place to look it up.

Francisco Olarte.

pgsql-general by date:

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