Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37050=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TvnCt-00074w-1w
	for pgsql-sql@arkaria.postgresql.org; Thu, 17 Jan 2013 11:00:27 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37050=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TvnCs-0000cP-AZ
	for pgsql-sql@arkaria.postgresql.org; Thu, 17 Jan 2013 11:00:26 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1TvnCr-0000cK-Mo
	for pgsql-sql@postgresql.org; Thu, 17 Jan 2013 11:00:25 +0000
Received: from plane.gmane.org ([80.91.229.3])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1TvnCi-0002NF-K7
	for pgsql-sql@postgresql.org; Thu, 17 Jan 2013 11:00:25 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1TvnCx-0004ip-8p
	for pgsql-sql@postgresql.org; Thu, 17 Jan 2013 12:00:31 +0100
Received: from ip-118-90-20-53.xdsl.xnet.co.nz ([118.90.20.53])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 17 Jan 2013 12:00:31 +0100
Received: from jasen by ip-118-90-20-53.xdsl.xnet.co.nz with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 17 Jan 2013 12:00:31 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Jasen Betts <jasen@xnet.co.nz>
Subject: Re: returning the number of rows output by a copy command from a
	function
Date: 17 Jan 2013 10:54:21 GMT
Organization: Dis (not Dat) Organisation
Lines: 12
Message-ID: <kd8l8t$96r$2@gonzo.reversiblemaps.ath.cx>
References: <50F6D883.50901@gmail.com> <CD1C4A00.6D1D%jsharrett@tidemark.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: ip-118-90-20-53.xdsl.xnet.co.nz
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-18 (Linux)
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 2013-01-16, James Sharrett <jsharrett@tidemark.net> wrote:
> The problem I have is that I get nothing back when the COPY is run inside
> the function other than what I explicitly return from the function so I
> don't have anything to parse.  It's odd that the record count in the
> function is treated differently than from sql query in GET DIAGNOSTIC
> since the format and information in the string (when run outside of the
> function) are exactly the same.

look into "get diagnostics"

-- 
⚂⚃ 100% natural



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