Hi all. I'd like to add an item to the PG wishlist (provided that one exists). In PL/PgSQL function bodies I'm using very often a pattern like this: EXECUTE SPRINTF( '...',... ); Where SPRINFT comes from here: http://wiki.postgresql.org/wiki/Sprintf It's by far more powerful, easy and effective than the standard "string concatenation" mechanism available for the plain EXECUTE. It's a different approach than the EXECUTE ... USING which has it's own rules and limitations (see chapter 38.5.4 for v8.4.4). The proposed approach doesn't know anything about symbols or other PL/PGSQL related syntax and can be used to build very complex (or otherwise impossible) dynamic SQL. I'd like to either see the SPRINTF function embedded either into the language, possibly with really variadic argument list (like stdarg.h in C) or into the EXECUTE itself with something like "EXECUTE <a string> SPRINTF <argument list>". Does this make any sense to you all? -- Vincenzo Romano NotOrAnd Information Technologies NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
