Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

COALESCE problems

Status
Not open for further replies.
dwhalen

dwhalen

Programmer
Feb 22, 2002
105
CA
I am trying to use COALESCE on two aggregrate functions. One being a AVG and the other a COUNT. When nothing is returned I want to display either text or say 0. Am I using the wrong thing here? This is my code:

COALESCE((date_trunc('minute',AVG(AGE(t.close_date,t.creation_date))))::varchar),'None ') AS TimeFrame,

COALESCE((COUNT(t.task_id)::varchar),0)

Any suggestions??

Thanks
 
Status
Not open for further replies.

Similar threads

saimaa
  • Locked
  • Question
count and group by problems postgresql
Replies
0
Views
34
saimaa
saimaa
eheidrich
  • Locked
  • Question
UPPER CASE problems
Replies
2
Views
37
Leland123
Leland123
NateUNI
  • Locked
  • Question
Problems with Date_Trunc
Replies
5
Views
220
flugh
flugh
sbraaa
  • Locked
  • Question
Memory problems with vacuum!!!
Replies
0
Views
32
sbraaa
sbraaa
NateUNI
  • Locked
  • Question
Problems with a Trigger Statement
Replies
1
Views
46
ceco
ceco

Part and Inventory Search

Sponsor

Back
Top