Re: Help with optional parameters

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Rob Tester <robtester(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help with optional parameters
Date: 2006-08-17 05:21:14
Message-ID: 20060817052114.GA77128@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Aug 16, 2006 at 08:39:49PM -0700, Rob Tester wrote:
> What is the best way to write a query and get the planner to use indexes
> when you have optional parameters and columns that can contain NULL values?

Have you considered building a query string and using EXECUTE?
That's not as "neat" as a static query but it might be worth testing.

--
Michael Fuhr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2006-08-17 10:26:00 Re: OT: OpenDatabase Model ?
Previous Message Rob Tester 2006-08-17 03:39:49 Help with optional parameters