Re: Help with optional parameters - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Help with optional parameters
Date
Msg-id 20060817052114.GA77128@winnie.fuhr.org
Whole thread Raw
In response to Help with optional parameters  ("Rob Tester" <robtester@gmail.com>)
List 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


pgsql-sql by date:

Previous
From: "Rob Tester"
Date:
Subject: Help with optional parameters
Next
From: Andrew Sullivan
Date:
Subject: Re: OT: OpenDatabase Model ?