[SQL] plpgsql function case statement

2001-09-12 Thread Peter Schmidt
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

Re: [SQL]plpgsql function case statement

2001-09-26 Thread Masaru Sugawara
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