From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] is it possible to use LIMIT and INTERSECT ? |
Date: | 1999-10-19 05:33:09 |
Message-ID: | 8432.940311189@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 1999-10-19 05:45:43 | Postgres problems with 6.4 / 6.5 (fwd) |
Previous Message | Oleg Bartunov | 1999-10-19 05:28:55 | Re: [HACKERS] is it possible to use LIMIT and INTERSECT ? |