On Jan 12, 2008 10:54 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > > Am I correct in understanding that the current behavior is inappropriate > > and shall be corrected at some point of time in future versions ? > > It's a bug, it's patched: > http://archives.postgresql.org/pgsql-committers/2008-01/msg00184.php
Thanks for the (unbelievable) quick response, I applied the patch on my production server and the problem is gone. tradein_clients=> \pset null NULL Null display is "NULL". tradein_clients=> SELECT * from temp.x where id is NULL; id ------ NULL (1 row) tradein_clients=> SELECT * from temp.x ; id ------ 1 2 NULL (3 rows) tradein_clients=> Regds mallah. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org