Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37047=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TvWnh-0006YZ-MN
	for pgsql-sql@arkaria.postgresql.org; Wed, 16 Jan 2013 17:29:21 +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+M37047=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TvWnh-0006uc-7K
	for pgsql-sql@arkaria.postgresql.org; Wed, 16 Jan 2013 17:29:21 +0000
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1TvWng-0006uX-HI
	for pgsql-sql@postgresql.org; Wed, 16 Jan 2013 17:29:20 +0000
Received: from mail-pb0-f54.google.com ([209.85.160.54])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1TvWnf-00088e-A9
	for pgsql-sql@postgresql.org; Wed, 16 Jan 2013 17:29:19 +0000
Received: by mail-pb0-f54.google.com with SMTP id wz12so837994pbc.13
	for <pgsql-sql@postgresql.org>; Wed, 16 Jan 2013 09:29:18 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:message-id:date:from:user-agent:mime-version:to:cc
	:subject:references:in-reply-to:content-type
	:content-transfer-encoding;
	bh=VjnxKiX1gBJtSAZORF6+sQo+cPA7Mcg5QWVeRWm7KME=;
	b=BPeNX+0CCDLVUehdYMiFoDX1nRYYjFwdj210JhBu5NMm5B4lzPWbENKiAZMxbxAzSh
	iOoFKizv51N6pwTU2+KU1Ui/LQc/LxPRFmEqH0lYGK3VOHsCHc+7kwAf1xuQE2IQYrUh
	uj32Xc00p0GgPParZBPHK3bHwzx+8BKUaNSBNzIpUD2tQHrfEERjD5olUqWtkkC8vFZW
	fdnib/Pk+fjMmYeXDL4BHcE7C4HDp6sJQ52oi28shdbqcz2Boo8MJ0ssJhRArQFq08MU
	MVEBxJUN2ybYQbnV/wq/ofoFmrgDF8Cx9zqjJ9cARwszVlcK+GKEw3b0s8L00epCaxkH
	x/mw==
X-Received: by 10.66.83.134 with SMTP id q6mr5544218pay.34.1358357358409;
	Wed, 16 Jan 2013 09:29:18 -0800 (PST)
Received: from [192.168.200.187] ([199.48.193.159])
	by mx.google.com with ESMTPS id ql9sm12620203pbc.61.2013.01.16.09.29.17
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Wed, 16 Jan 2013 09:29:17 -0800 (PST)
Message-ID: <50F6E36B.3090005@gmail.com>
Date: Wed, 16 Jan 2013 09:29:15 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:17.0) Gecko/20130107 Thunderbird/17.0.2
MIME-Version: 1.0
To: James Sharrett <jsharrett@tidemark.net>
CC: pgsql-sql@postgresql.org
Subject: Re: returning the number of rows output by a copy command from
	a function
References: <CD1C4CC8.6D2C%jsharrett@tidemark.net>
In-Reply-To: <CD1C4CC8.6D2C%jsharrett@tidemark.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
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 01/16/2013 09:26 AM, James Sharrett wrote:
> Integer
>

Well copy is returning a string, so try changing the type. You will have 
to parse that string for the count.

-- 
Adrian Klaver
adrian.klaver@gmail.com


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