Re: [SQL] simple recursive function in plpgsql fails

2002-06-13 Thread Tom Lane
Andrew Hammond <[EMAIL PROTECTED]> writes: > [ problems with a recursive plpgsql function ] Yeah, there are some known bugs there :-(. AFAICS this cannot be fixed properly until we get around to doing the querytree restructuring that I keep ranting about --- in particular, making a clean distinc

[SQL] simple recursive function in plpgsql fails

2002-06-13 Thread Andrew Hammond
ians=# SELECT version(); version --- PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4 My goal is to find the last occurance of a pattern in a string. As a helper function, I wrote this: DROP F