#13 oracle versus postgreSQL (2)

[Thomas]

Hi,

1) in: f2w-1.4/reports/cnt_r_by_date
---------------------------------------

* the original code ( with ORA-936):
select to_char(r_entered,<dtml-sqlvar dfmt
type=string>) as dgroup,
date(r_entered) as entered,
to_char(r_entered,'<dtml-var LLdate_fmt
missing="DD-MM-YYYY" sql_quote>') as day,
sum(decode(r_status,'t',1,0)) as numopen,
count(*) as count
from request
group by 1,2,3
order by 2 desc;

* my suggestion (it works):
select
dgroup,
entered,
day,
sum(decode(r_status,'t',1,0)) as numopen,
count(*) as count
from
( select
to_char(r_entered,<dtml-sqlvar dfmt type=string>)
as dgroup,
to_date(r_entered) as entered,
to_char(r_entered,'<dtml-var LLdate_fmt
missing="DD-MM-YYYY" sql_quote>') as day,
r_status
from request)
group by dgroup, entered, day
order by 2 desc

==================================================

2) in: f2w-1.4/reports/cnt_r_complex
---------------------------------------

please change from:
group by month_entered, c_name

to:
group by to_char(r_entered,'YYYY/MM'), c_name

Thomas

[Peter Harris]

Logged In: YES
user_id=8911

Is this a good way to do it, Todd?