Specifying text to substitute for NULLs in selects

Поиск
Список
Период
Сортировка
От pcreso@pcreso.com
Тема Specifying text to substitute for NULLs in selects
Дата
Msg-id 494662.65727.qm@web33206.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Specifying text to substitute for NULLs in selects  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Gerhard Heift
Дата:
Сообщение: Re: UPDATE tuples with a sub-select
Следующее
От: Brent Wood
Дата:
Сообщение: Defining string to represent null values in select