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 851B68BA087
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Feb 2005 17:51:04 +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 87677-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Feb 2005 17:50:54 +0000 (GMT)
Received: from smtp3.pacifier.net (smtp3.pacifier.net [64.255.237.173])
	by svr1.postgresql.org (Postfix) with ESMTP id 08D4A8BA052
	for <pgsql-sql@postgresql.org>; Thu, 17 Feb 2005 17:50:53 +0000 (GMT)
Received: from nefesh (ip16.gte154.dsl-acs2.sea.iinet.com [207.202.154.16])
	by smtp3.pacifier.net (Postfix) with SMTP id 1D1476DCDC
	for <pgsql-sql@postgresql.org>; Thu, 17 Feb 2005 09:50:52 -0800 (PST)
From: "Ray Madigan" <ray@madigans.org>
To: "Pgsql-Sql" <pgsql-sql@postgresql.org>
Subject: LOOP?
Date: Thu, 17 Feb 2005 08:59:14 -0800
Message-ID: <AEEJIDLCICLNLPOJHFEEAEFDFCAA.ray@madigans.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Importance: Normal
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200502/196
X-Sequence-Number: 20307

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};

I am trying to write a general function where from instance to instance the
columns in the record change.  If I can't do this I will have to create a
new function for each temporary table.

Is this possible or should I quit looking;

FOR record IN {something related to NEW } LOOP

END LOOP;