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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
