Re: [GENERAL] Making NULLs visible.
От | Steve Doliov |
---|---|
Тема | Re: [GENERAL] Making NULLs visible. |
Дата | |
Msg-id | Pine.GSO.3.96.981009145702.361A-100000@gecko обсуждение исходный текст |
Ответ на | Re: [GENERAL] Making NULLs visible. (Bruce Momjian <maillist@candle.pha.pa.us>) |
Ответы |
Re: [GENERAL] Making NULLs visible.
|
Список | pgsql-general |
> > Is there a way to make postgreSQL 'show' nulls rather than have them appear > > as blank fields? > I am always looking for suggestions on how to display nulls. It is on > the TODO list. I'd suggest a query option. The query option could filter the displayed data through a temporary table which would do a NULL to char() conversion as it were. similar to psql-> set query option id null as "NULL" then the interface would do the following if given a query query passed to psql select a, b, from mydata; psql would interpret as create table temp (a text, b text); and then run a query to populate temp casting the values of a b from mydata as necessary and taking null values and setting them to what the user specified (a good choice would be "NULL" of course). steve
В списке pgsql-general по дате отправления: