Re: [GENERAL] Is there a RECORD[] type in plpgsql?

Thanks Merlin, do you know what the syntax would be? Can't seem to find it anywhere and im getting an error using 8.3.7 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Is there a RECORD[] type in plpgsql?

Im using the same... FOR record_or_row IN query LOOP at the beginning of a function and at the end of a function. Is there a way to save the query results in a RECORD[] type so that I don't have to run the query twice? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak

[GENERAL] plpgsql and control structures

I noticed that if I use... IF (TG_OP = 'DELETE' AND OLD.myColumn) THEN -- Do something END IF; when an insert happens, I get an error that 'OLD' has not been assigned. I would of thought that the control structure would just ignored the rest of the 'if' statement if the first part (TG_OP) was f