Nick Howden <[EMAIL PROTECTED]> writes:
> Using postgres 7.2.3 the query planner seems to lose interest in using
> indexes when DISTINCT is used.
I don't think this is a bug. DISTINCT requires a sort step, so even
though you have a LIMIT, the planner has to plan on the basis of reading
the entir
[EMAIL PROTECTED] writes:
> There are no aggregate functions for type RELTIME
Use type INTERVAL. Reltime is obsolescent.
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregiste
Paul Mamin ([EMAIL PROTECTED]) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
There are no aggregate functions for type RELTIME
Long Description
create table a (b reltime);
insert into a values ('00:02:00');
select sum(b) from a;
sum
-
120
