From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | daniel(at)manitou-mail(dot)org |
Cc: | listas(at)guedesoft(dot)net, robertmhaas(at)gmail(dot)com, pavel(dot)stehule(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Why format() adds double quote? |
Date: | 2016-01-27 01:46:23 |
Message-ID: | 20160127.104623.1166770620314832766.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> 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.
What is the "visual hint"? If you are talking about psql's output, it
never adds "visual hint" (double quotations).
If you are talking about the string handling in a program, what kind
of program cares about "visiual"?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2016-01-27 02:03:11 | Re: pgbench stats per script & other stuff |
Previous Message | Tatsuo Ishii | 2016-01-27 01:40:57 | Re: Why format() adds double quote? |