Thread: Varidic function (printf) not found within a trigger
Hi all. Within a trigger function I need to call a variadic function (actually the printf found on http://wiki.postgresql.org/wiki/Sprintf). When the trigger is fired I get the following: function printf(text, timestamp without time zone, timestamp without time zone, text) does not exist LINE 1: SELECT printf( $l1$ ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Is this a bug or am I missing something important? -- Vincenzo Romano NotOrAnd Information Technologies NON QVIETIS MARIBVS NAVTA PERITVS
2010/1/20 Vincenzo Romano <vincenzo.romano@notorand.it>: > Hi all. > > Within a trigger function I need to call a variadic function (actually > the printf found on http://wiki.postgresql.org/wiki/Sprintf). > When the trigger is fired I get the following: > > function printf(text, timestamp without time zone, timestamp without > time zone, text) does not exist > LINE 1: SELECT printf( $l1$ > ^ > HINT: No function matches the given name and argument types. You > might need to add explicit type casts. > you have to do explicit cast from timestamp to text Pavel > Is this a bug or am I missing something important? > > -- > Vincenzo Romano > NotOrAnd Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >