DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language;
	b=Oyyn2nx4vi1yXdlDDTFl0lTmV56hwbfWaVILcYcY1WpVLBWEBqcqLVDiRRDQEJLWmFQi/6b37Ehq4qC9hj+qxIxwqwmM4WA+FRJYJ6e3C7/23SgHa2ZRRtGGBlLgomMXBuHC1s4O5Zbte5ceaUA5H6gVGHJmlka0yFcoVwm5dq8=
	;
From: "David Johnston" <polobo@yahoo.com>
To: "'tlund79'" <thomas.lund@eniro.no>, <pgsql-sql@postgresql.org>
References: <1320758213629-4974235.post@n5.nabble.com>
In-Reply-To: <1320758213629-4974235.post@n5.nabble.com>
Subject: Re: Issue with a variable in a function
Date: Tue, 8 Nov 2011 12:27:45 -0500
Message-ID: <006801cc9e3b$bb177ec0$31467c40$@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AQIc7Y08LCnApvXrT9LS7gCo2efv+JUCmFiQ
Content-Language: en-us

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of tlund79
Sent: Tuesday, November 08, 2011 8:17 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Issue with a variable in a function


The issue relates to the variable "prosjektkode" ($4). 

CREATE OR REPLACE FUNCTION ppr_data(aarstall int, frauke int, tiluke int,
prosjektkode int) RETURNS int AS $$ DECLARE antall bigint;

-----------/Original Message----------

Read about "ARRAY"s

Change your function signature to something like:

CREATE OR REPLACE FUNCTION ppr_data(aarstall int, frauke int, tiluke int,
prosjektkode int[] )  -- Note the change to int[] from int for prosjektkode

David J.