pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: ncm@zembu.com
To: pgsql-hackers@postgreSQL.org
Subject: Re: PL/pgsql EXECUTE 'SELECT INTO ...'
Date: Wed, 7 Feb 2001 21:33:47 -0800
Message-ID: <20010207213347.A19999@store.zembu.com> (raw)
In-Reply-To: <10497.981602102@sss.pgh.pa.us>
References: <10497.981602102@sss.pgh.pa.us>

On Wed, Feb 07, 2001 at 10:15:02PM -0500, Tom Lane wrote:
> I have looked a little bit at what it'd take to make SELECT INTO inside
> an EXECUTE work the same as it does in plain plpgsql  ...
> If we do nothing now, and then implement this feature in 7.2, we will
> have a backwards compatibility problem: EXECUTE 'SELECT INTO ...'
> will completely change in meaning.
> 
> I am inclined to keep our options open by forbidding EXECUTE 'SELECT
> INTO ...' for now. ... if [not] I think we'll regret it later.

I agree, disable it.  But put a backpatch into contrib along with 
a reference to this last e-mail.  Anybody who cares enough can
apply the patch, and will be prepared for the incompatibility.

Nathan Myers
ncm@zembu.com



view thread (8+ messages)  latest in thread

Message-ID: <20010207213347.A19999@store.zembu.com>
Permalink:  ../20010207213347.A19999@store.zembu.com/
Also on:    postgresql.org/message-id/20010207213347.A19999@store.zembu.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: ncm@zembu.com, pgsql-hackers@postgreSQL.org
  Subject: Re: PL/pgsql EXECUTE 'SELECT INTO ...'
  In-Reply-To: <20010207213347.A19999@store.zembu.com>
  References: <10497.981602102@sss.pgh.pa.us> <20010207213347.A19999@store.zembu.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox