Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 0D9AD288154
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  9 Nov 2011 06:41:49 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 79037-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  9 Nov 2011 10:41:42 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from sam.nabble.com (sam.nabble.com [216.139.236.26])
	by mail.postgresql.org (Postfix) with ESMTP id 4CA78288153
	for <pgsql-sql@postgresql.org>; Wed,  9 Nov 2011 06:41:41 -0400 (AST)
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <thomas.lund@eniro.no>) id 1RO5b9-00084k-84
	for pgsql-sql@postgresql.org; Wed, 09 Nov 2011 02:41:39 -0800
Date: Wed, 9 Nov 2011 02:41:39 -0800 (PST)
From: tlund79 <thomas.lund@eniro.no>
To: pgsql-sql@postgresql.org
Message-ID: <1320835299242-4977361.post@n5.nabble.com>
In-Reply-To: 
 <B4EB9C9043754B458497ED2C0CD37CF240590F8E29@fixoosr61.findexa.net>
References: <1320758213629-4974235.post@n5.nabble.com>
	<006801cc9e3b$bb177ec0$31467c40$@yahoo.com>
	<B4EB9C9043754B458497ED2C0CD37CF240590F8E29@fixoosr61.findexa.net>
Subject: Re: Issue with a variable in a function
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.778 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	URI_HEX=1.122
X-Spam-Level: 
X-Archive-Number: 201111/43
X-Sequence-Number: 36016

I solved this one by trial and error. You were right I needed brackets to
indicate an array, but also needed to replace "in ($4)" with "= any ($4)"

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issue-with-a-variable-in-a-function-tp4974235p4977361.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.