Re: BUG #5377: group by problem

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "michel rosa" <mrosa(at)geomatic(dot)ch>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5377: group by problem
Date: 2010-03-18 13:34:36
Message-ID: 4BA1E59C020000250002FEA1@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"michel rosa" <mrosa(at)geomatic(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-03-18 14:25:53 Re: text cast to bool bug
Previous Message lsasha 2010-03-18 12:18:54 BUG #5378: Little inaccuracy in the manual