X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id A23E99DC840
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Dec 2005 14:46:44 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 76742-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Dec 2005 14:46:44 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by postgresql.org (Postfix) with ESMTP id 26B309DC827
	for <pgsql-sql@postgresql.org>; Thu, 29 Dec 2005 14:46:41 -0400 (AST)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id jBTIkdJL008291
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Thu, 29 Dec 2005 11:46:41 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id jBTIkdYd053756;
	Thu, 29 Dec 2005 11:46:39 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.4/8.13.4/Submit) id jBTIkda9053755;
	Thu, 29 Dec 2005 11:46:39 -0700 (MST) (envelope-from mfuhr)
Date: Thu, 29 Dec 2005 11:46:39 -0700
From: Michael Fuhr <mike@fuhr.org>
To: Ken Winter <ken@sunward.org>
Cc: "'Bricklen Anderson'" <banderson@presinet.com>,
	"'PostgreSQL pg-sql list'" <pgsql-sql@postgresql.org>
Subject: Re: Arrays in PL/pgSQL routines?
Message-ID: <20051229184639.GA53686@winnie.fuhr.org>
References: <43B42273.9030602@presinet.com>
	<005a01c60ca4$f79e3bb0$6603a8c0@kenxp>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <005a01c60ca4$f79e3bb0$6603a8c0@kenxp>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.055 required=5 tests=[AWL=0.055]
X-Spam-Score: 0.055
X-Spam-Level: 
X-Archive-Number: 200512/246
X-Sequence-Number: 23788

On Thu, Dec 29, 2005 at 01:23:28PM -0500, Ken Winter wrote:
> That works.  (Odd that the initialization seems to be necessary to make it
> work.)  Thanks!  Yes, I'm using version 7.4.

7.4.what?  Absence of initialization shouldn't cause a syntax error;
at least it doesn't in 7.4.10.  However, in 7.4 you do have to
initialize an array before assigning to its elements, else the array
will remain NULL (initialization isn't necessary in the latest 8.x
releases).

-- 
Michael Fuhr