From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: string function - "format" function proposal |
Date: | 2010-09-06 15:05:29 |
Message-ID: | AANLkTikY7kyidk3e3PGkY-VcST6Su3=Wsne97FqxrQXk@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2010/9/6 Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>:
> On Mon, Sep 6, 2010 at 11:24 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> So? You'd need to quote the values anyway, in general. If you want
>> something that will be valid SQL you'd better include the functionality
>> of quote_literal() in it.
>>
>> I'm not sure that it's a good idea to have any type-specific special
>> cases.
>
> As I remember, the original motivation of %v formatter is
> some DBMSes don't like quoted numeric literals. However,
> Postgres accepts quoted numerics, and we're developing Postgres.
>
> So, our consensus would be %v formatter should be removed
> completely from the format function.
>
I think so tag that quotes all without numbers can be very useful, but
it isn't too much important for me. I can live without them.
Regards
Pavel
> --
> Itagaki Takahiro
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Haggerty | 2010-09-06 15:32:00 | Re: git: uh-oh |
Previous Message | Tom Lane | 2010-09-06 14:53:35 | Re: git: uh-oh |