> select when_stopped as when_happened,
> 1 as order_hint
> from transaction t
> where '2005-10-25 15:00:00' <= when_stopped
> and when_stopped <= '2005-10-26 10:00:00'
> union all
> select when_stopped as when_happened,
> 2 as order_hint
> from transaction t
> where '2005-10-25 15:00:00' <= when_stopped
> and when_stopped <= '2005-10-26 10:00:00'
> order by when_happened, order_hint;
hmm, try pushing the union into a subquery...this is better style
because it's kind of ambiguous if the ordering will apply before/after
the union.
select q.when from
(
select 1 as hint, start_time as when [...]
union all
select 2 as hint, end_time as when [...]
) q order by q.seq, when
question: why do you want to flatten the table...is it not easier to
work with as records?
Merlin