LOOP?

From: "Ray Madigan" <ray(at)madigans(dot)org>
To: "Pgsql-Sql" <pgsql-sql(at)postgresql(dot)org>
Subject: LOOP?
Date: 2005-02-17 16:59:14
Message-ID: AEEJIDLCICLNLPOJHFEEAEFDFCAA.ray@madigans.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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;

Responses

  • Re: LOOP? at 2005-02-17 18:05:54 from Richard Huxton

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-02-17 17:26:29 Re: pg primary key bug?
Previous Message pginfo 2005-02-17 16:41:51 Re: pg primary key bug?