Postgres Pro
Downloads
Home   >   mailing lists

Defining string to represent null values in select - Mailing list pgsql-general

From Brent Wood
Subject Defining string to represent null values in select
Date
Msg-id 787214.36592.qm@web33203.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Defining string to represent null values in select
List pgsql-general
Tree view 
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
selectoutput, 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 columns in the query, but is there a simpler way, like
settinga system variable to specify this? 

Thanks,

  Brent Wood

pgsql-general by date:

Previous
From: pcreso@pcreso.com
Date:
Subject: Specifying text to substitute for NULLs in selects
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Specifying text to substitute for NULLs in selects