X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C4BE78BA315
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Feb 2005 18:06:06 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 91749-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Feb 2005 18:05:58 +0000 (GMT)
Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net
	[194.217.242.88])
	by svr1.postgresql.org (Postfix) with ESMTP id 602DC8BA301
	for <pgsql-sql@postgresql.org>; Thu, 17 Feb 2005 18:05:58 +0000 (GMT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-30.mail.demon.net with esmtp (Exim 4.42)
	id 1D1q2E-000DSL-0p; Thu, 17 Feb 2005 18:05:54 +0000
Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 4F988165EF; Thu, 17 Feb 2005 18:05:44 +0000 (GMT)
Message-ID: <4214DD02.2030207@archonet.com>
Date: Thu, 17 Feb 2005 18:05:54 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Ray Madigan <ray@madigans.org>
Cc: Pgsql-Sql <pgsql-sql@postgresql.org>
Subject: Re: LOOP?
References: <AEEJIDLCICLNLPOJHFEEAEFDFCAA.ray@madigans.org>
In-Reply-To: <AEEJIDLCICLNLPOJHFEEAEFDFCAA.ray@madigans.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.064 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200502/198
X-Sequence-Number: 20309

Ray Madigan wrote:
> I am writing a trigger to inspect a row of a temporary table to determine if
> the row has any null columns,  I will return as soon as I find a null
> column.  I ran across this in the manual and It seems like I could use
> 
> The FOR-IN-EXECUTE statement is another way to iterate over rows:
> [<<label>>]
> FOR record_or_row IN EXECUTE text_expression LOOP
> statements
> END LOOP;
> 
> postgresql has a RECORD type which is an abstract row.
> 
> Does it have any fields to tell the length?
> 
> Does it have an accessor function like new.element(index};

Short answer - no to the above.

You'll not find what you want in plpgsql, perhaps look at pltcl or 
plperl for this sort of thing.

--
   Richard Huxton
   Archonet Ltd