--- "M. Scott Smith" <mssmit1@afterlife.ncsc.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;