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

From Itagaki Takahiro
Subject Re: string function - "format" function proposal
Date
Msg-id AANLkTimLcRjqT1umE6ntWyW8qEZtKG4PyjuxUL77G8=n@mail.gmail.com
Whole thread Raw
In response to string function - "format" function proposal  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: string function - "format" function proposal
List pgsql-hackers
> 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: %% => %

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: {{ => {, }} => }
 

-- 
Itagaki Takahiro


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Why do we have a database specification in .pgpass?
Next
From: Robert Haas
Date:
Subject: Re: string function - "format" function proposal