Lists: | pgadmin-support |
---|
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 |
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
From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | George Pavlov <gpavlov(at)mynewplace(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: NULL vs empty string in Query Tool |
Date: | 2006-01-06 20:03:20 |
Message-ID: | 43BECD08.6030400@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgadmin-support |
George Pavlov wrote:
>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.
>
Still on the list, as the original mail.
Regards,
Andreas