Re: [repost] partial index / funxtional idx or bad sql?

On Mon, May 12, 2003 at 09:03:38PM -0700, csajl wrote:
> 
> wow.
> 
> that did it.  so much for my knowing SQL...
> > 
> > How about something like:
> > 
> > select c.class_id, c.areacode, c.title from
> >  classifieds c,
> >  (select distinct areacode from cm_areacode where site_id='10') a
> >  where c.class_cat_id='1' and c.areacode=a.areacode;
> > 

Wow, I'll have to keep that in mind. Shouldn't the optimizer be able to
handle that? Could this get added to the TODO?
-- 
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"