pgsql: Add new SQL function, format(text).

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add new SQL function, format(text).
Date: 2010-11-21 03:34:37
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-committers

Add new SQL function, format(text).

Currently, three conversion format specifiers are supported: %s for a
string, %L for an SQL literal, and %I for an SQL identifier. The latter
two are deliberately designed not to overlap with what sprintf() already
supports, in case we want to add more of sprintf()'s functionality here

Patch by Pavel Stehule, heavily revised by me. Reviewed by Jeff Janes
and, in earlier versions, by Itagaki Takahiro and Tom Lane.



Modified Files
doc/src/sgml/func.sgml | 25 +++++
doc/src/sgml/plpgsql.sgml | 23 ++++
src/backend/utils/adt/varlena.c | 195 ++++++++++++++++++++++++++++++++++++
src/include/catalog/pg_proc.h | 4 +
src/include/utils/builtins.h | 2 +
src/test/regress/expected/text.out | 108 ++++++++++++++++++--
src/test/regress/sql/text.sql | 32 ++++++-
7 files changed, 374 insertions(+), 15 deletions(-)


Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2010-11-21 11:35:18 pgsql: Bump catversion. Should have done this as part of format(text)
Previous Message Tom Lane 2010-11-20 20:07:32 pgsql: Further cleanup of indxpath logic related to IndexOptInfo.opfami