Re: function likes sprintf

From: "Mikhail V. Majorov" <mik@ttn.ru>


> Hi all!
>
> Do pgsql function like sprintf() in C?
> I write trigger function using plpgsql.
>
> This my code:
> sqlcommand := textcat(''CREATE USER '',NEW.usename);
> sqlcommand := textcat(sqlcommand, ''WITH SYSID '');
> sqlcommand := textcat(sqlcommand, NEW.id);
> sqlcommand := textcat(sqlcommand, ''WITH PASSWORD '');
> sqlcommand := textcat(sqlcommand, passwd);
> INSERT INTO todo_surep_user VALUES (sqlcommand, now(), '''');
>
> How do I replace "textcat" on another construct of language?

You can use the || operator such as:

sqlcommand := "CREATE USER " || NEW.usename || "WITH SYSID" ...

If you are after the more advanced formatting %7.3f stuff you'll need to
look at the various procedural languages (pltcl,plperl) - you could write
you own function to emulate sprintf but I don't think the interface supports
a variable number of parameters.

- Richard Huxton