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 kin
Hi,
I'm porting a bunch of queries from MySQL to Postgres 7.4 and am having a problem with
one
particular area. For example, a query like this works in MySQL:
select
to_char(myCol,'Mon YY')
from
myTable
group by
to_char(myCol,'MM ')
order by
to_char(myCol,'MM ')
Postgres will gi