Re: operator is not unique: integer || integer - Mailing list pgsql-general

Klint Gore schrieb:
> > RAISE NOTICE "error during validation % :",
> 'ks:"'||ks||'"@"'||loopdate||'"';  (here LoopDate is a DateTime)
>
> You know you can use more than one % in a raise and it will take care
> of the data types?
>
yes i know. the real code looks like this:

S:='another ABG found on ks:"'||ks||'"@"'||loopdate||'"';
PERFORM internalcreatemessage(current_user, 'W', S);


greets.