Re: Help with optional parameters

Curtis Scheer wrote:> I noticed this one by searching in the archives, as I am working with 
some> "optional" parameters myself and noticed your solution. I just wanted to> make one improvement suggestion which
isinstead of checking whether 
 
or not> a parameter has been used simply start your query like so> Query_base := 'SELECT * FROM my_table WHERE 1 =1;>
Ifyou do that then you can just add on any parameters you need or 
 
not add> any at all. I think that seems to be a bit simpler than having a 
has_param"> Boolean variable.
True, I think I was too focused on the "clean" output, your solution 
wastes less cycles and is more readable...

Snipet updated,

Thanks,
--
MaXX