troubleshooting Question

Pervasive SQL (PSQL): Expression evaluation error

Avatar of Perfishent
PerfishentFlag for United States of America asked on
Databases
8 Comments1 Solution1269 ViewsLast Modified:
Why does this code cause an expression evaluation error?

SELECT SUM(pay_amt)
FROM pr_wcomp
WHERE YEAR(pay_date) = 2013

But this code does not:

SELECT pay_amt
FROM pr_wcomp
WHERE YEAR(pay_date) = 2013

The pay_amt column is a double, and the pay_date column is a date.
ASKER CERTIFIED SOLUTION
Bill Bach
President and Btrieve Guru

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros