Thread

Re: [QUESTIONS] Join-crazy newbie may be pushing the limits :-)

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su> — 1998-01-19T04:06:09Z

Felix Morley Finch wrote:
> 
> >>In article <34C1BD06.1712ABAC@sable.krasnoyarsk.su>, "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su> writes:
> 
> > Felix Morley Finch wrote:
> >>
> >> I tried searching and ran into several new lessons in SQL; I ended up
> >> with this --
> >>
> >> select name from names n, keys k1, keys k2, family f1, family f2
> >> where ((k1.key ~* 'xyzzy') and (k1.id = f1.key) and (n.id = f1.name))
> >> or ((k2.key ~* 'plugh) and (k2.id = f2.key) and (n.id = f2.name));
> >>
> >> and psql never returned.  This is a test database, maybe 20 records.
> >> If I keep it down to a single keyword, it works fine.
> 
> > EXPLAIN ?
> > Did you try SET geqo TO 'on=1' ?
> 
> I just tried it --
> 
>         WARN:Bad value for # of relations (1)
> 
> I tried ON=2 which gave no WARNING but didn't fix the join.  I tried
> OFF and same result.

(So, this is problem of not just old optimizer...)

Could you post me output of

EXPLAIN VERBOSE _select_statement_ ?

Vadim