From: | MaXX <bs139412(at)skynet(dot)be> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Help with optional parameters |
Date: | 2006-09-21 22:48:14 |
Message-ID: | eev4rk$2l3h$1@talisker.lacave.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ezequias Rodrigues da Rocha | 2006-09-22 13:52:00 | Group by minute |
Previous Message | Curtis Scheer | 2006-09-21 22:18:48 | Re: Help with optional parameters |