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: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Here's another, quicker way to do it.

SELECT column1,
       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-2017 The PostgreSQL Global Development Group