2010/9/6 Itagaki Takahiro <itagaki.takah...@gmail.com>: > On Mon, Sep 6, 2010 at 11:24 PM, Tom Lane <t...@sss.pgh.pa.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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
