From: Terry Brick <terry_brick2000@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Formatting Functions and Group By
Date: Tue, 13 Apr 2004 10:49:19 -0700 (PDT)
Message-ID: <20040413174919.79405.qmail@web11508.mail.yahoo.com> (raw)
In-Reply-To: <24390.1081877598@sss.pgh.pa.us>
Thank you both for your responses. That's just what I needed.... and thanks for catching my
mistake Tom. And may I say that I am VERY happy to be moving to Postgres. The lack of a native
Win32 version was thing only thing holding us back from Postgres previously.
I think this is the only kind of query I will have had difficulty porting. I'm looking forward to
ditching MySQL and never looking back!! :)
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Ah, good ol' MySQL :-( ... let the user do what he wants whether the
> result is well defined or not ...
>
> I'd suggest doing the grouping/ordering numerically rather than
> textually. For instance,
>
> select
> to_char(date_trunc('month', myCol), 'Mon YY')
> from
> myTable
> group by
> date_trunc('month', myCol)
> order by
> date_trunc('month', myCol);
>
> Now this assumes you really want a time-based ordering, which the quoted
> example doesn't give --- you've got month sorting to the left of year,
> is that really what you want? If it is then you'd need to go
>
> group by
> date_trunc('month', myCol)
> order by
> to_char(date_trunc('month', myCol), 'MM YYYY')
>
> regards, tom lane
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: terry_brick2000@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: Formatting Functions and Group By
In-Reply-To: <20040413174919.79405.qmail@web11508.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox