[SQL] Help with optional parameters

I have the need to have optional values for a query in a stored procedure that I am building. (using postgres 8.1.4). This particular query executes against a huge table (several million rows) and has six optional parameters that can be sent to the function. If one of the parameters is null then th

Re: [SQL] Help with optional parameters

this tip.  On 8/17/06, MaXX <[EMAIL PROTECTED]> wrote: Rob Tester wrote:> I have the need to have optional values for a query in a stored procedure> that I am building. (using postgres 8.1.4). This particular query> executes> against a huge table (several million rows) and has six op