Brent Wood <[EMAIL PROTECTED]> schrieb:
>
> 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.
COALESCE:
test=*# select coalesce(NULL, 'NaN');
coalesce
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
