Postgres Pro
Downloads
Home   >   mailing lists

Specifying text to substitute for NULLs in selects - Mailing list pgsql-general

From pcreso@pcreso.com
Subject Specifying text to substitute for NULLs in selects
Date
Msg-id 494662.65727.qm@web33206.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Specifying text to substitute for NULLs in selects  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
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: Gerhard Heift
Date:
Subject: Re: UPDATE tuples with a sub-select
Next
From: Brent Wood
Date:
Subject: Defining string to represent null values in select