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

From Tatsuo Ishii
Subject Re: Why format() adds double quote?
Date
Msg-id 20160127.142401.917458238048251764.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Why format() adds double quote?  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Why format() adds double quote?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
>> > I can agree, so current behave can be useful in some cases, but still it
>> is
>> > bug (inconsistency) between PostgreSQL parser and PostgreSQL escaping
>> > functions.
>> >
>> > Currently, any multibyte char can be unescaped identifier (only
>> apostrophes
>> > are tested). We should to test white chars too.
>>
>> Really? I thought we do that test.
>>
> 
> what you are expecting from this test? UTF single quotes are tested only in
> quote functions probably.

I just wanted to demonstrate multibyte chars including ASCII white
spaces can be an identifier.

> We should to test white chars too.

What do you exactly propose regarding white chars and multibyte chars
here? Maybe you propose to consider non ASCII white spaces (treate
them as ASCII white spaces)?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Pavel
> 
> 
>>
>> test=# create table t6("あいう えお" int);
>> CREATE TABLE
>> test=# \d t6
>>          Table "public.t6"
>>    Column    |  Type   | Modifiers
>> -------------+---------+-----------
>>  あいう えお | integer |
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Why format() adds double quote?
Next
From: Amit Kapila
Date:
Subject: Re: CustomScan under the Gather node?