Re: BUG #5377: group by problem - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5377: group by problem
Date
Msg-id 4BA1E59C020000250002FEA1@gw.wicourts.gov
Whole thread Raw
In response to BUG #5377: group by problem  ("michel rosa" <mrosa@geomatic.ch>)
List pgsql-bugs
"michel rosa" <mrosa@geomatic.ch> wrote:

> I get extras rows for 2010-03-02

I'm not sure I understand your concern.
Is it that the result set includes these rows?:

>   to_char   | cost | count
> ------------+------+-------
>  2010-03-02 |  2.0 |     7
>  2010-03-02 |  3.0 |     3

What do you get from?:

select * from evadeo.tileshop
where status=2
and source=3
and upload_date = '2010-03-02'
and cost > 1.5;

-Kevin

pgsql-bugs by date:

Previous
From: "michel rosa"
Date:
Subject: BUG #5377: group by problem
Next
From: Tom Lane
Date:
Subject: Re: text cast to bool bug