| From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | ROWTYPE initialization question |
| Date: | 2006-11-09 15:37:23 |
| Message-ID: | 45534B33.8060209@magproductions.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
'lo list,
I have a plpgsql SP where I loop through a cursor. I have an internal
variable that keeps the previous row, so that I can compare it with the
current row in the cursor.
Like so;
DECLARE
current table%ROWTYPE;
previous table%ROWTYPE;
BEGIN
LOOP
FETCH tableCur INTO current;
-- Do stuff
But, in this loop I need to compare the previous row to the current one.
To do that I need to know whether a row was assigned to 'previous', or
there'll be very little to compare (if it doesn't throw an error).
How do I check for that?
I guess it would be like this, but I'd like to be sure.
IF previous IS NOT NULL
THEN
-- Compare previous and current column values
END IF
previous := current;
END LOOP;
END;
Thanks in advance,
--
Alban Hertroys
alban(at)magproductions(dot)nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2006-11-09 15:47:42 | Re: Why overlaps is not working |
| Previous Message | Alvaro Herrera | 2006-11-09 15:34:55 | Re: authentication question |