Re: [GENERAL] Views + UNION ALL = Slow ?

2004-10-20 Thread Hagen Hoepfner
The difficulty is, that your view-based statement do not make use of any index. So the query must look at each tuple. It seems, that union all requires a full scan of the participates relations. I dont know if it is possible but try to create an index on the view ;-) Hagen Otto Blomqvist

Re: [GENERAL] plpython question

2004-10-19 Thread Hagen Hoepfner
I don't know plpythonu but python ;-) As I really understood your problem you want to return strings. In Pytho return(OK ) should work ;-) Hagen Sim Zacks wrote: I have the following function and I am getting an invalid syntax error when I try to run it. I have tried the function a number of