| 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: | Whole Thread | Raw Message | 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;
| 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? |