On Sep 14, 2006, at 14:04 , D'Arcy J.M. Cain wrote:
On Thu, 14 Sep 2006 10:33:19 -0700
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
By the way, I removed the currency symbol from the output. Would
removing the commas also make sense? These are the sorts of things
that can be added by applications.
I don't think that we should be providing *any* presentation
beyond the
actual representation of the data. What if it is not US dollars? :)
That's what locale is for. It looks at that to determine that sort of
stuff including currency symbol before I removed it.
If you force the locale into the money type, then the entire column
must be of the same currency. That seems like an unnecessary
limitation. Does your type support banker's rounding?
-M
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match