From: | Alain(dot)Tesio(at)sip(dot)fr |
---|---|
To: | "M(dot) Scott Smith" <mssmit1(at)afterlife(dot)ncsc(dot)mil>, pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Problem with limit / union / etc. |
Date: | 1999-12-28 18:29:04 |
Message-ID: | C1256855.00659131.00@applications.sip.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
--- "M. Scott Smith" <mssmit1(at)afterlife(dot)ncsc(dot)mil> wrote:
> select
> event.title
> from
> event, event_url, url
> where
> date_start >= 'now'::date
> and event.oid = event_url.eventid
> and url.oid = event_url.urlid
>
> union
>
> select
> event.title
> from
> event,event_url
> where
> date_start >= 'now'::date
> and event.oid not in
> (select distinct event_url.eventid from event_url)
>
> order by event.date_start asc limit $total;
Maybe the limit is applied only on the second query.
What about the following query ?
Alain
==
select
event.title,date_start
into
temp tmp_events
from
event, event_url, url
where
date_start >= 'now'::date
and event.oid = event_url.eventid
and url.oid = event_url.urlid
limit $total;
insert
tmp_events
select
event.title,date_start
from
event,event_url
where
date_start >= 'now'::date
and event.oid not in
(select distinct event_url.eventid from event_url)
limit $total;
select
title
from
tmp_events
order by event.date_start asc limit $total;
drop table tmp_events;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-12-28 20:13:25 | Re: [SQL] Problem with limit / union / etc. |
Previous Message | M. Scott Smith | 1999-12-28 16:17:43 | Problem with limit / union / etc. |