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

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