Skip site navigation (1) Skip section navigation (2)

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: 2007-05-24 20:30:11
Message-ID: 2CC69F840555CB43B04195F218CCB57F8F596B@COENGEX01.cctus.com (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

pgadmin-support by date

Next:From: Adib SaikaliDate: 2007-05-24 20:45:15
Subject: Bug Report: Preferences Dialogbox does not resize after I change the font size
Previous:From: Melvin DavidsonDate: 2007-05-24 20:19:32
Subject: Re: Feature Request -Show NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group