Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Feature Request - Show Null
- From: "Melvin Davidson" <mdavidson(at)cctus(dot)com>
- To: "Ketema Harris" <ketema(at)gmail(dot)com>, "Pgadmin Support" <pgadmin-support(at)postgresql(dot)org>
- Subject: Re: Feature Request - Show Null
- Date: Thu, 24 May 2007 14:30:11 -0600
Here's another, quicker way to do it.
SELECT column1,
column2,
COALESCE(maybe_null_column, 'NULL')
FROM your_table;
Note: If maybe_null_column is not a character data type,
then you need to coerce it. ie: maybe_null_column::text
- References:
- Feature Request
- From: Ketema Harris
- Feature Request
- Prev by Date: Re: Feature Request -Show NULL
- Next by Date: Bug Report: Preferences Dialogbox does not resize after I change the font size
- Previous by thread: Re: Bug Report: Preferences Dialogbox does not resize after I change the font size
- Next by thread: Re: Feature Request
- Indexes: