I'm having trouble finding the best solution for the following plpgsql
function.
The function does the following:
- gets an integer from table1 (using function getHighMark)
- Updates info.lastused with the latest timestamp from usage_log where
info.id = usage_log.id, but only if the sequence numb
Peter Schmidt wrote:
>I'm having trouble finding the best solution for the following plpgsql
>function.
>The function does the following:
Hi, I post in this mailing list for the first time. :-)
I think your pl/pgsql function runs properly, but there
is likely to exist another SQL pattern. In