On Feb 9, 2015, at 8:53 PM, sridhar bamandlapally <sridhar.bn1@xxxxxxxxx> wrote: > > the issue is, while DML its empty string and while SELECT its comparing with NULL The issue is, empty string is NOT the same as null, and expecting select for null to match empty strings is a bug, which you need to fix. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
