In a plpgsql function, I have a variable of type table%rowtype
I populate the row by calling "select into <variable> * from <table>"
then i change some stuff like "<variable>.<field> := <new value>"
now i want to insert the row into the table as a new row - is there an
easy way to do this?
i know i could do "insert into <table> values ( <variable>.<field 1>,
<variable>.<field 2>, ... );"
but that is a lot of typing, and it seems like there should be an
easier way.
-Bryan