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

Oleg Bartunov wrote:
> 
> Tom,
> 
> patch was applied smoothly to 6.5.2
> What's the syntax ?
> 
> 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)
> 
> 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 limit 5
> 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;
> 

As the limit is applied to the final result, I guess you can have only one 
LIMIT per query.

So try removing the limit 5 before intersect .

-----------
Hannu