Hi David: On Mon, Mar 14, 2016 at 4:22 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote: >> But a right-aligning string output routine needs to be used. ... >> Summarising, any combination can be easily done with a single round of >> replace. > See also: > http://www.postgresql.org/docs/9.5/interactive/functions-string.html > format(formatstr text [, formatarg "any" [, ...] ]) You mean to use it to right align the replaced string ( i.e. format('%12s',replace(...)) ) or is there a code I do not know off which can be used to achieve the global result ( I use it but it seems to be like a restricted sprintf which can not do the supress the zero stuff ) ? Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
