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 is instead 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;
> If you 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
