Re: [HACKERS] is it possible to use LIMIT and INTERSECT ?

Oleg Bartunov <oleg@sai.msu.su> writes:
> Thanks Tom,
> I synced REL6_5 tree, compile, install but still query

> select  a.msg_id, c.status_set_date, c.title
>         from Message_Keyword_map a, messages c, keywords d
>         where c.status_id =1 and d.name ~* 'sun'  and a.key_id=d.key_id
>               and c.msg_id=a.msg_id
>          intersect
> select  a.msg_id, a.status_set_date, a.title
>         from messages a where a.status_id = 1 and a.title ~* 'sun' limit 10;

> produces more than 10 rows !

If you'd care to provide a reproducible stand-alone test case I'll look
into it further.  I do not feel like trying to reverse-engineer your
table declarations.
        regards, tom lane