Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8027=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1XCxzp-00017Y-L4
 for pgsql-docs@arkaria.postgresql.org; Thu, 31 Jul 2014 21:34:45 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8027=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1XCxzp-0001j3-43
 for pgsql-docs@arkaria.postgresql.org; Thu, 31 Jul 2014 21:34:45 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <marko@joh.to>) id 1XCxzn-0001gI-Ic
 for pgsql-docs@postgresql.org; Thu, 31 Jul 2014 21:34:43 +0000
Received: from mail-lb0-f178.google.com ([209.85.217.178])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <marko@joh.to>) id 1XCxzk-0006o0-9x
 for pgsql-docs@postgresql.org; Thu, 31 Jul 2014 21:34:41 +0000
Received: by mail-lb0-f178.google.com with SMTP id c11so2496364lbj.23
 for <pgsql-docs@postgresql.org>; Thu, 31 Jul 2014 14:34:37 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
 :subject:content-type;
 bh=hgoyzWipHUu4eNJ4lxBDqoSA7RA0ZUbu1tLGZRIaNPE=;
 b=j/l4cjmL7HJ9ax6RsZms8jH2A63IvNhZEpO/PwxMgykMrZofwSOaJzkLJHS+LGcTEa
 iKZmSnhJMv/7w9cP5K8dKIrU7JdhnfL7SZf5inIFKXNE9KH8Fe/NNuqknwEJRuOQHR5Q
 6Oyx4DIYhIpaT90vwFDkDikkesCRMZHDA5kOQIqVCyraaKhxwIyunY7eSirhGvceQds0
 6rcRpmj0602Xv4mFi1iYslgYT4NIidlgF665k2f5bsggsxPyQG/2SnubTRYxn1qt2jcS
 qXk1ZLc7Le4M2Grr6NoY/A3tKOenYcOMQMAa12xZyFTrIUBJEv3b50heYk3RPrbKoDEk
 qe3Q==
X-Gm-Message-State: 
 ALoCoQmQFmBlHsCJKG5EaDHQn9VZ3S6L4569bbZOHYlcX4nZvYby0DbBYJP1DZQ39Pzm1EgTCb3V
X-Received: by 10.112.235.42 with SMTP id uj10mr949481lbc.80.1406842477569;
 Thu, 31 Jul 2014 14:34:37 -0700 (PDT)
Received: from dalli.local (c-5eeaaaab-74736162.cust.telenor.se.
 [94.234.170.171])
 by mx.google.com with ESMTPSA id zv7sm9981466lbb.31.2014.07.31.14.34.36
 for <pgsql-docs@postgresql.org>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Thu, 31 Jul 2014 14:34:36 -0700 (PDT)
Message-ID: <53DAB66B.6080405@joh.to>
Date: Thu, 31 Jul 2014 23:34:35 +0200
From: Marko Tiikkaja <marko@joh.to>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: PG Docs <pgsql-docs@postgresql.org>
Subject: PL/PgSQL INTO (used to be BUG #8870)
Content-Type: multipart/mixed; boundary="------------050904000600090506010002"
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

This is a multi-part message in MIME format.
--------------050904000600090506010002
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

As discussed in #8870, the docs make unfounded claims on INTO.  Here's a 
patch removing the incorrect part.



.marko

--------------050904000600090506010002
Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0";
 name="plpgsql_bull.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="plpgsql_bull.patch"

*** a/doc/src/sgml/plpgsql.sgml
--- b/doc/src/sgml/plpgsql.sgml
***************
*** 1023,1032 **** DELETE ... RETURNING <replaceable>expressions</replaceable> INTO <optional>STRIC
     </tip>
  
      <para>
!      If a row or a variable list is used as target, the query's result columns
!      must exactly match the structure of the target as to number and data
!      types, or else a run-time error
!      occurs.  When a record variable is the target, it automatically
       configures itself to the row type of the query result columns.
      </para>
  
--- 1023,1029 ----
     </tip>
  
      <para>
!      When a record variable is the target, it automatically
       configures itself to the row type of the query result columns.
      </para>
  

--------------050904000600090506010002
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--------------050904000600090506010002--