On Tue, 2010-02-09 at 17:38 -0500, Tom Lane wrote:
> The results certainly ought to be the same (although perhaps not with
> the same ordering) --- if they aren't, please provide a reproducible
> test case.
The results are the same, this is not a problem.
> As for efficiency, though, 8.1 didn't u
Dimi Paun writes:
>> From what I've read on the net, these should be very similar,
> and should generate equivalent plans, in such cases:
> SELECT DISTINCT x FROM mytable
> SELECT x FROM mytable GROUP BY x
> However, in my case (postgresql-server-8.1.18-2.el5_4.1),
> they generated different res
On 9 February 2010 21:46, Dimi Paun wrote:
> >From what I've read on the net, these should be very similar,
> and should generate equivalent plans, in such cases:
>
> SELECT DISTINCT x FROM mytable
> SELECT x FROM mytable GROUP BY x
>
> However, in my case (postgresql-server-8.1.18-2.el5_4.1),
> t
