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?
Mik.