Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: "Aspire Something" <aspire420@hotpop.com>,
	"pgsql Sql" <pgsql-sql@postgresql.org>
Subject: Re: Arrays Or Loop
Date: Thu, 6 Mar 2003 09:17:05 -0800
User-Agent: KMail/1.4.3
References: <001101c2e3a5$d507c380$c9c832c0@societykotla>
In-Reply-To: <001101c2e3a5$d507c380$c9c832c0@societykotla>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200303060917.05298.josh@agliodbs.com>

Aspire,

>  2. Can we use array for the above thing as
>      a. Make an array of the valid roll_numbers. such as
>  ('IDX'=>'ROLL_NUMBER'........)
>      b. Now select the array element by the index which will produce the
>  roll_number and work on it.
>      c. Array could be build by for loop
>  3. Will the array approch execute code fast. if yes can you please give me
>  some refrences so that i can actually
>              build one such function.

Unfortunately, the current version of PL/pgSQL have problems with array 
support.  So if you want to test this with arrays, you will have to use 
another language, such as C or Python.

>  4. Lastly if i use views will they help in fas execution

No.   If you want fast execution, try writing the procedure in C.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco