Re: [HACKERS] PL/pgsql EXECUTE 'SELECT INTO ...' - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: [HACKERS] PL/pgsql EXECUTE 'SELECT INTO ...'
Date
Msg-id Pine.LNX.4.30.0102082036370.1362-100000@peter.localdomain
Whole thread Raw
In response to PL/pgsql EXECUTE 'SELECT INTO ...'  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] PL/pgsql EXECUTE 'SELECT INTO ...'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane writes:

> I am inclined to keep our options open by forbidding EXECUTE 'SELECT
> INTO ...' for now.  That's more than a tad annoying, because that leaves
> no useful way to do a dynamically-built SELECT, but if we don't forbid
> it I think we'll regret it later.

You can always use CREATE TABLE AS.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query never returns ...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] PL/pgsql EXECUTE 'SELECT INTO ...'