Re: operator is not unique: integer || integer

> another example?:
>
> RAISE NOTICE "error during validation % :", 'ks:"'||ks||'"@[EMAIL PROTECTED]
"'|| 
> loopdate||'"';  (here LoopDate is a DateTime)

Ehm... What's wrong with RAISE NOTICE "error during validation  
ks:"%"@[EMAIL PROTECTED]
"%" :', ks, loopdate; ? (I don't quite understand the purpose  
of that colon at the end, btw).
Allows you to format the date to your liking too, just add a to_char 
(loopdate, <format string>).

I know these were just a few examples of your troubles, but so far it  
appears it's desirable to get rid of them for better code.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,481ffc80927661001715755!



-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general