Anil said...Is ForAll better or table operator now for updates?
You can't update against a table function. Perhaps you mean INSERT INTO ... SELECT, in which case you could use this for the SELECT, for use an INSERT in a FORALL. They both have different pros and cons, so there is not a "better" one. It depends.
Tim Thompson said...Hi,
Just noticed a complication that took an hour or so to figure out:
If one of the columns in the rowtype is a float then casting the array to a table will work, but you will be unable to reference the columns in it. To solve this create a record of the same structure but substituted a number for the float and use the record type to define the associative array rather than a row type.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!