Oleg Bartunov <oleg@sai.msu.su> writes:
> patch was applied smoothly to 6.5.2
> 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 ~* 'moon' 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 ~* 'moon' limit 5;
> produces (10 rows)
Hmm. It seemed to work as expected in current --- maybe there is
another bug still lurking in 6.5.*. I'll look when I get a chance.
regards, tom lane