Re: Re: proposal: a width specification for s specifier (format function), fix behave when positional and ordered placeholders are used
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Stephen Frost <sfrost@snowman.net>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2013-01-28T21:08:25Z
Lists: pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes: > On 28 January 2013 20:40, Pavel Stehule <pavel.stehule@gmail.com> wrote: >> 2013/1/28 Dean Rasheed <dean.a.rasheed@gmail.com>: >>> flags - not currently implemented. Pavel's second patch adds support >>> for the '-' flag for left justified string output. However, I think >>> this should support all datatypes (i.e., %I and %L as well as %s). >> no - surely not - I% and L% is PostgreSQL extension and left or right >> alignment is has no sense for PostgreSQL identifiers and PostgreSQL >> literals. > Left/right alignment and padding in printf() apply to all types, after > the data value is converted to a string. Why shouldn't that same > principle apply to %I and %L? I agree with Dean --- it would be very strange for these features not to apply to all conversion specifiers (excepting %% of course, which isn't really a conversion specifier but an escaping hack). regards, tom lane