Re: encoding problems - Mailing list pgsql-novice

From Tom Lane
Subject Re: encoding problems
Date
Msg-id 23804.1205253695@sss.pgh.pa.us
Whole thread Raw
In response to encoding problems  (Cliff Nieuwenhuis <cliff@nieusite.com>)
Responses Re: encoding problems
List pgsql-novice
Cliff Nieuwenhuis <cliff@nieusite.com> writes:
> I'm not sure how to ask this question.  I have written a function, and with
> PostgreSQL 8.0.13 I can do a "\df+" and see something like this under Source
> Code:
>     DECLARE
>         result text;
> ...

> If I create the same function on my computer running PostgreSQL 8.3.0 and try
> the \df+ then the Source Code shows:

> \x09DECLARE
> \x09\x09result text;
> ...

That's not an encoding problem, that's an intentional behavioral change
in the way that psql formats strings for display.

I guess it's a bit annoying if you were hoping that tabs would be useful
for pretty-printing purposes.  Should we reconsider what's done with a
tab in mbprint.c?

            regards, tom lane

pgsql-novice by date:

Previous
From: Cliff Nieuwenhuis
Date:
Subject: encoding problems
Next
From: Joshua
Date:
Subject: simple question concerning plpgsql and SQL Functions