Re: plpgsql select into - Mailing list pgsql-novice

From Roger Mason
Subject Re: plpgsql select into
Date
Msg-id y65y28voyoy.fsf@mun.ca
Whole thread Raw
In response to Re: plpgsql select into  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
David G. Johnston writes:

> I suggest you should pretend that SQL's "SELECT INTO" doesn't exist.  If
> you want to create a table from a result write: "CREATE TABLE AS" and then
> a normal select query.  In particular the entire "action" command is kept
> whole instead of needing to put a bunch of column names in between the
> "SELECT" and the "INTO" - and you also are less likely to confuse the
> plpgsql feature of the same form.

Thank you David.  I will try to heed that advice.

Roger



pgsql-novice by date:

Previous
From: Roger Mason
Date:
Subject: Re: plpgsql select into
Next
From: Roger Mason
Date:
Subject: triggers and parameters