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 !
Regards, Oleg
On Tue, 19 Oct 1999, Tom Lane wrote:
> Date: Tue, 19 Oct 1999 00:42:08 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] is it possible to use LIMIT and INTERSECT ?
>
> I wrote:
> > 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.
>
> Yup, this change that was already in current is also needed:
>
> *** src/backend/parser/gram.y.orig Mon Oct 18 23:59:35 1999
> --- src/backend/parser/gram.y Mon Oct 18 23:55:18 1999
> ***************
> *** 2768,2773 ****
> --- 2768,2775 ----
> /* finally attach the sort clause */
> first_select->sortClause = $2;
> first_select->forUpdate = $3;
> + first_select->limitOffset = nth(0, $4);
> + first_select->limitCount = nth(1, $4);
> $$ = (Node *)first_select;
> }
> if (((SelectStmt *)$$)->forUpdate != NULL && QueryIsRule)
>
>
>
> I have updated both current and REL6_5 branches.
>
> regards, tom lane
>
> ************
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
