[GENERAL] New Zealand Postgis DBA job vacancy

Mat be of interest to someone here... http://careers.eroad.co.nz/vacancies/showVacancy/11 Brent Wood

[GENERAL] Specifying text to substitute for NULLs in selects

Hi, I can specify the text used to represent a null value in output from copy, but I'd like to do something similar is select output, eg: all NULL values are represented by NA or NaN. I can't find anything in the docs about this. This could be managed using case statements around all the colu