Re: Why format() adds double quote? - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: Why format() adds double quote?
Date
Msg-id 2f1ee47a-77b2-409f-a9f1-24f1673c6025@mm
Whole thread Raw
In response to Re: Why format() adds double quote?  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Why format() adds double quote?  ("Dickson S. Guedes" <listas@guedesoft.net>)
Re: Why format() adds double quote?  (Tatsuo Ishii <ishii@postgresql.org>)
Re: Why format() adds double quote?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
    Tatsuo Ishii wrote:

> IMO, it's a bug or at least an inconsistency

Personally I don't see this change being good for everything.

Let's play devil's advocate:

create table abc(U&"foo\2003" int);

U+2003 is 'EM SPACE', in Unicode's General Punctuation block.

With the current version, format('%I', attname) on this column is:
"foo "

With the patched version, it produces this:
foo 

So the visual hint that there are more characters at the end is lost.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite



pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: Add generate_series(date,date) and generate_series(date,date,integer)
Next
From: Alvaro Herrera
Date:
Subject: Re: Speedup twophase transactions