Re: string function - "format" function proposal - Mailing list pgsql-hackers

From Robert Haas
Subject Re: string function - "format" function proposal
Date
Msg-id AANLkTik7JYQnj2Z2ns1jS6OGSqEwbkqUTLO74bBnDGNu@mail.gmail.com
Whole thread Raw
In response to Re: string function - "format" function proposal  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: string function - "format" function proposal  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Thu, Oct 14, 2010 at 2:25 AM, Itagaki Takahiro
<itagaki.takahiro@gmail.com> wrote:
>> Let's make format support %s, %i, and %l, as well as
>> allowing things like %$3l (meaning, escape the third argument as a
>> literal and interpolate here), and call it good.
>
> Your idea is:
>  % [ $ pos ] format  -- ex. %$3l , %l
>  Escapes: %% => %
>
> Just for information, $ and pos are reversed in C sprintf.
>  % [ pos $ ] format  -- ex. %3$l , %l
>  Escapes: %% => %

Oh, woops.  I intended to copy the way C works.

> IMHO, I like {} syntax as like as C# because the format strings are extensible.
>  { pos [ : format ] } -- ex {3:l}, {3} (, and {l} could be also supported)
>  Escapes: {{ => {, }} => }

My personal preference (and Pavel's, I guess) is to use the C-like
syntax.  But I wouldn't be upset if consensus congealed around some
other option.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [JDBC] Support for JDBC setQueryTimeout, et al.
Next
From: Itagaki Takahiro
Date:
Subject: Re: [BUGS] rollback to savepoint leads to transaction already in progress