> At 18:36 +0200 on 9/10/98, Bruce Momjian wrote:
>
>
> > I am always looking for suggestions on how to display nulls. It is on
> > the TODO list.
>
> Here is my suggestion, admittedly a bit cheeky:
>
> Implement an NVL function - one that dictates a NULL in a field and
> converts it to whate
At 18:36 +0200 on 9/10/98, Bruce Momjian wrote:
> I am always looking for suggestions on how to display nulls. It is on
> the TODO list.
Here is my suggestion, admittedly a bit cheeky:
Implement an NVL function - one that dictates a NULL in a field and
converts it to whatever value is require
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > Yes, \ always outputs as \\, excepts someone changed it last week, and I
> > am requesting a reversal. Do you like the \N if it is unique?
>
> Well, it's certainly clear, but could be confused with \n (newline). Can we
> have \0 instead
> Yes, \ always outputs as \\, excepts someone changed it last week, and I
> am requesting a reversal. Do you like the \N if it is unique?
Well, it's certainly clear, but could be confused with \n (newline). Can we
have \0 instead?
Taral
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > How do you feel about displaying nulls as \N, as we do in the COPY
> > output?
>
> And when I put \N in a text field? How do I distinguish? We need some kind
> of escaping system here... like turn '\' into '\\' and then '\N' is unique
>
> How do you feel about displaying nulls as \N, as we do in the COPY
> output?
And when I put \N in a text field? How do I distinguish? We need some kind
of escaping system here... like turn '\' into '\\' and then '\N' is unique
and non-textual. :) Also allows us to output control characters, etc
> > > Is there a way to make postgreSQL 'show' nulls rather than have them appear
> > > as blank fields?
>
> > I am always looking for suggestions on how to display nulls. It is on
> > the TODO list.
>
> I'd suggest a query option. The query option could filter the displayed
> data through a t
> Dear All,
>
> Is there a way to make postgreSQL 'show' nulls rather than have them appear
> as blank fields?
>
> code|name
> +
> 5678|
> |
> (2 rows)
>
> brecard5=> select * from test;
> code|name
> +--
> 1234|one two three four
> 5678|
> |
> |
> (4 row
