From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] is it possible to use LIMIT and INTERSECT ? |
Date: | 1999-10-18 08:22:31 |
Message-ID: | 380AD8C7.BBA3E3E9@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1999-10-18 08:28:32 | Re: [HACKERS] is it possible to use LIMIT and INTERSECT ? |
Previous Message | Zakkr | 1999-10-18 06:37:49 | Re: [HACKERS] to_char(), md5() (long) |