Re: NULL vs empty string in Query Tool

From: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: NULL vs empty string in Query Tool
Date: 2006-01-06 19:13:07
Message-ID: CCB89282FCE1024EA3DCE687A96A516403E96C6F@ehost010-6.exch010.intermedia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Chris Reigrut wrote:
> Is there any way to distinguish between an empty string ('') and a
NULL
> string value in the query tool?

I'd like to resurrect this question from a while ago. It does not seem
like it got any response. It would be great if pgAdmin's Query Tool had
a setting similar to psql's "\pset NULL" formatting option. It is very
easy to confuse the two and most query tools that I know of allow for
that.

George

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2006-01-06 20:03:20 Re: NULL vs empty string in Query Tool
Previous Message Laurent Yaish 2006-01-06 18:16:02 Query editor broken <new connection> feature in 1.4.1