| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Daniel Schuchardt <daniel_schuchardt(at)web(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: operator is not unique: integer || integer |
| Date: | 2008-05-06 06:36:46 |
| Message-ID: | C7A3CB29-6516-4AE2-8680-DF114539701F@solfertje.student.utwente.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> another example?:
>
> RAISE NOTICE "error during validation % :", 'ks:"'||ks||'"@"'||
> loopdate||'"'; (here LoopDate is a DateTime)
Ehm... What's wrong with RAISE NOTICE "error during validation
ks:"%"@"%" :', 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2008-05-06 06:48:26 | Re: more custom C function fun |
| Previous Message | Dan "Heron" Myers | 2008-05-06 06:05:18 | Re: more custom C function fun |