Hello all.
In the tail end of converting an app from MySQL to psql. I have this code :
IF(days_complete <= -120, job_price,0) AS Days_120,
IF(days_complete BETWEEN -119 AND -90, job_price,0) AS Days_90,
IF(days_complete BETWEEN -89 AND -60, job_price,0) AS Days_60,
IF(days_complete BETWEEN -59 AND
Hello everyone.
I am a recent convert from quite an old version of MySQL. I have an ancient
business app/database that I dump into MySQL overnight, then run a whole set of
queries on to form tables that users then query using Excel DSN.
Up to now, because MySQL didn't have subqueries, these routi
